Registered aircraft · 3,127

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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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:2016-05-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
  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:2016-05-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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.

N10TFBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 602-1217 N10TPAeronautical Technologies Inc · Clovis, NMBuilt 2006 · S/N 802-0246 N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310 N1101PJerry Price & Sons Inc · Joiner, ARBuilt 2024 · S/N 802A-1101 N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475 N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481 N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486 N1114AEvans David J · Parker, COS/N 208B0309 N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559 N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514 N1115MPa1 208b-0356 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0356 N1116GAircraft Structures International Corp · Enid, OKBuilt 1994 · S/N 208B0402 N1117GBrylee Investment Corp · Wilmington, DEBuilt 1993 · S/N 208B0370 N1119VMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0383 N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6 N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665 N111MZCrb Companies LLC · Tulsa, OKBuilt 1998 · S/N FL-210 N111RFEaston Air LLC · Middletown, RIBuilt 2003 · S/N 259 N111VRDftf LLC · Des Moines, IABuilt 1991 · S/N 1006 N111WGAhuva LLC · Port Alsworth, AKBuilt 2004 · S/N 555 N1120WMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0388 N1122RRegistered aircraftBuilt 2019 · S/N 802A-0794 N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483 N1128LArne Aviation LLC · Suffolk, VABuilt 1996 · S/N 208B0536 N1129GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0924 N112FAFast Ag Air LLC · Watertown, SDBuilt 2025 · S/N 802A-1199 N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467 N1132FUS Government · Washington, DCBuilt 1999 · S/N 208B0741 N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027 N114HBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1533 N114JPJohnson Airspray Inc · Argyle, MNS/N T34-033 N1154FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 208B1065 N115CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0011 N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669 N115FARegistration Pending · Roseland, NERegistration pendingBuilt 2025 · S/N 802A-1250 N115LABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 402B-1152 N115TTNo Delay LLC · Tickfaw, LABuilt 1992 · S/N FL-74 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N116FATesk Aviation LLC · Steele, MOBuilt 2025 · S/N 802A-1231 N116KPAtchley Joshua K DBA · Portageville, MOBuilt 2016 · S/N 602-1282 N116THMile High Aviation Inc · Yuma, COBuilt 2025 · S/N 602-1388 N11703Gsd Aerial LLC · O Neill, NEBuilt 2022 · S/N 802A-0949 N117BBKustatan Leasing LLC · Nikiski, AKBuilt 1962 · S/N 1511 N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N117NURegistered aircraftBuilt 1998 · S/N 4636138 N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030 N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17 N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202

Back to AD 2016-05-13