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.

N208TWCaravan Air LLC · Oxford, CTBuilt 1998 · S/N 208B0671 N208VVT&T Highcountry Flying Service LLC · Saint Anthony, IDS/N 502B-0560 N208WWWestwind Aero Group LLC · Phoenix, AZBuilt 1998 · S/N 208B0721 N208YYAircraft Structures International Corp · Enid, OKBuilt 1995 · S/N 208B0453 N208ZZSpeedstar Express LLC · Carson City, NVBuilt 1991 · S/N 208B0260 N209LAWest Valley Aviation Inc · Five Points, CABuilt 2011 · S/N 802A-0409 N209STSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 4697209 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N20FDGilmer Aircraft Leasing LLC · Wilmington, DEBuilt 1998 · S/N LJ-1528 N20KAAltair Advanced Industries Inc · Bellingham, WABuilt 1966 · S/N 1652TB29 N210BTGood Aviation LLC · Oshkosh, WIBuilt 1979 · S/N P21000555 N210EXUnited States Navy · Patuxent River, MDS/N FL-388 N2111TMccool Air Service Inc · Mc Cool Junction, NEBuilt 1998 · S/N T34-252 N211GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-211 N2126TTidwell Sprayers Inc · Dimmitt, TXBuilt 1998 · S/N T15-038 N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212 N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214 N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951 N212LWPf Aviation LLC · Carl Junction, MOBuilt 2001 · S/N BB-1766 N212PKOc Aviation LLC · Victoria, TXBuilt 2005 · S/N 668 N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357 N213DBMarshall Air Systems Inc · Charlotte, NCBuilt 1993 · S/N BB-1450 N213MCMcr Aviation LLC · Austin, TXBuilt 1991 · S/N FA-216 N213REWhital Enterprises LLC · Dover, DEBuilt 2002 · S/N 230 N214GBPterodactyl Inc · Wilmington, DEBuilt 1999 · S/N BB-1668 N214NXLife Flight Network LLC · Aurora, ORBuilt 2010 · S/N 1214 N214PNavajo Nation · Window Rock, AZBuilt 1991 · S/N LJ-1293 N214RLLassco LLC · Middletown, DEBuilt 2021 · S/N 802-0896 N214SCAzul Air LLC · Dover, DEBuilt 1976 · S/N LW-96 N215SDEastern Stearman Inc Trustee · Leesburg, VABuilt 2001 · S/N 4697049 N216CSAlpine Aviation Inc · Provo, UTBuilt 1983 · S/N U-216 N216KCBlack Kettle Inn LLC · Cabool, MOBuilt 1998 · S/N 216 N216TATailwinds Air Inc · Morganza, LABuilt 2013 · S/N 602-1227 N217EBRapids Camp Lodge Inc · King Salmon, AKFirst renewal noticeBuilt 1996 · S/N 154 N2185MFreefall Express · Gardiner, NYBuilt 1968 · S/N 687 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N21AUBoeing Co · Renton, WABuilt 2005 · S/N 606 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N220GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-220 N220MARegistration Pending · Chestertown, MDRegistration pendingBuilt 2002 · S/N 248 N220TTShannair LLC · Saint Louis, MOS/N BB-462 N220UM3k Aviation LLC · Birmingham, MIBuilt 2004 · S/N 4697183 N221BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-168 N221GSendero Aviation Services LLC · Dublin, TXBuilt 1998 · S/N FL-198 N221JDPerrydise Aviation LLC · Tulsa, OKBuilt 1991 · S/N 1010 N222CMBriar Lakes Productions Inc · Palestine, TXBuilt 1995 · S/N 111 N222CYBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 1990 · S/N BB-1370 N222PVJ Turbines Inc · Wilmington, DEBuilt 1997 · S/N FL167 N222RLTalon Air Service Inc · Soldotna, AKBuilt 1964 · S/N 1570 N2239BBeery Milo A · Clarinda, IAS/N T41-217

Back to AD 2016-05-13