Registered aircraft · 729

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-23-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820 N100QTSouthwest Aviation Inc · Marshall, MNBuilt 1976 · S/N LJ689 N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N100VReserve Aviation LLC · Dallas, TXBuilt 1978 · S/N LJ-796 N100WBBbcc Foundation · Moses Lake, WABuilt 1966 · S/N LJ-139 N101BSOn Mission Network · Dallas, TXBuilt 1968 · S/N LJ-375 N101SNGorsuch Aviation LLC · Lancaster, OHBuilt 1981 · S/N BE-118 N103BABemidji Aviation Services Inc · Bemidji, MNBuilt 1971 · S/N LD-435 N103MPJoyce George E · Franklinville, NCS/N LF-50 N104BABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-235 N106BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N LD-409 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N10AGBaron Associates LLC · Norfolk, VABuilt 1980 · S/N BE-100 N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310 N10XJNext Phase Ia LLC · Las Vegas, NVS/N LW-117 N110BABemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-279 N110BMDrewcy Inc · Wilmington, DEBuilt 1978 · S/N LW-273 N110ELForsyth Technical Community College · Winston Salem, NCBuilt 1965 · S/N LJ-71 N111JAMillennium Falcon 2020 LLC Trustee · Wilmington, DEBuilt 1974 · S/N LW-84 N111TCGrady Excavating Inc · Mukilteo, WABuilt 1978 · S/N LW-305 N112HGAlghazzawi Hani · Toledo, OHS/N LJ529 N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37 N113SHHill Lawrence E · Marion, MTBuilt 1970 · S/N B-18 N115PACentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-117 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 N11638N3701d LLC · Wilmington, NCBuilt 1983 · S/N LJ-1052 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N116DGStructures Inc · Mesa, AZBuilt 1981 · S/N BE-116 N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20 N117MFJet Sales Of Stuart LLC · Stuart, FLBuilt 1978 · S/N LJ-779 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118NLPandd Partnership LLC · Oro Valley, AZBuilt 1981 · S/N BE-111 N11DTAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-11 N11SNSsj Holdings LLC · Modesto, CABuilt 1982 · S/N LJ-1036 N1205SCounty Line Aviation LLC · Benton, KSBuilt 1979 · S/N LW-319 N121BArgo Aviation LLC · Potsdam, NYBuilt 1972 · S/N LW-21 N121JGGo Consultants LLC · Wilmington, DES/N LJ-996 N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707 N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32 N123MHBryan-Kennedy LLC · Tulsa, OKBuilt 1974 · S/N LW-104 N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045 N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093 N127TXItb Solutions LLC · Palm City, FLBuilt 1981 · S/N BE-106 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N12AXEsc-100 Executive Consulting Services LLC · Pharr, TXBuilt 1978 · S/N LW-293 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12

Back to AD 81-23-01 R1