Registered aircraft · 3,126

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.

N264B264b LLC · Wilmington, DEBuilt 2001 · S/N 46-97028 N264BRKeller James B · Palo Alto, CABuilt 2023 · S/N K038 N265FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 802A-1265 N266RDGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1633 N268FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2026 · S/N 802A-1268 N26EDynamic Avlease Inc · Bridgewater, VAS/N LW-62 N26TGKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636193 N270CLRegistration Pending · Chesterfield, MORegistration pendingBuilt 1990 · S/N 208B0232 N271LAA+ Aviation Services LLC · Goodland, KSBuilt 2012 · S/N 802A-0471 N271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 622 N271ZRegistration Pending · Helena, MTRegistration pendingBuilt 2023 · S/N 4698271 N272GXFreedom Aviation LLC · Anaconda, MTBuilt 2024 · S/N K072 N272ZZBig Flats LLC · Durham, NCBuilt 1943 · S/N 25509(43-48248)N274PMPlanemasters Ltd · West Chicago, ILFirst renewal noticeBuilt 1998 · S/N 208B0705 N275LARts Ventures LLC · San Antonio, TXBuilt 1992 · S/N LJ1275 N275LHProject Tango Inc Trustee · Wilmington, DEBuilt 2001 · S/N 200 N276ATBoardman Air Service LLC · Henderson, NEBuilt 2024 · S/N 802A-1110 N276JBChris Allen Aviation LLC · Naples, FLBuilt 1998 · S/N FL-219 N276MABank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 20800276 N277ATBoardman Air Service LLC · Henderson, NEBuilt 2016 · S/N 602-1277 N277GERltwf LLC · Fiddletown, CABuilt 1990 · S/N BB-1389 N277GLDiamondback Equipment Leasing LLC · Avondale, AZBuilt 1991 · S/N BB-1406 N278ATBoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802A-0953 N278JLarkin Matthew W · Lafayette, CABuilt 2002 · S/N 4697127 N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011 N27BFJab Air LLC · Ponte Vedra Beach, FLBuilt 1981 · S/N 31T-8104038 N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268 N27MGAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0650 N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740 N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344 N282PMPlanemasters Ltd · West Chicago, ILBuilt 2002 · S/N 208B0981 N283JDDurham Aircraft LLC · Port Aransas, TXBuilt 1991 · S/N FL-69 N283PMPlanemasters Ltd · West Chicago, ILBuilt 1999 · S/N 208B0774 N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734 N285KCCourt Reporter Assignments Inc · Bullhead City, AZBuilt 2023 · S/N 4698285 N285PBBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 585 N285RBButler National Inc · New Century, KSBuilt 1999 · S/N FL-264 N286PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0631 N288AFMod-Pac Corp · Portsmouth, NHBuilt 2023 · S/N 2288 N288ATN38ry LLC · California, MDBuilt 1987 · S/N FA134 N289ATN999mg LLC · California, MDBuilt 1991 · S/N FL-65 N289PCTuca 27 LLC · Lewes, DEBuilt 1991 · S/N 546 N28ANPa1 208b-0751 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B0751 N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540 N290BCTraven Ricardo Siro · Georgetown, SCBuilt 2004 · S/N 1092 N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132 N290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N LJ-519 N291DFRmb Leasing Inc · Dover, DEBuilt 1998 · S/N LJ-1534 N292PSteelman Aviation Inc · Las Vegas, NVBuilt 2005 · S/N 630 N294DRValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4697184

Back to AD 2016-05-13