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.

N118AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 468508019 N118AJCat Agri Aviation Inc · Walnut Ridge, ARBuilt 2009 · S/N 802A-0343 N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077 N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541 N119JWWestern Pilot Service Inc · League City, TXBuilt 2010 · S/N 802A-0383 N119KPBig Windy Aviation Inc · Watson, ARBuilt 2019 · S/N 602-1305 N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119 N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502 N11DGAir Grace LLC · Blanco, TXBuilt 2024 · S/N K060 N120KPPrairie Ag Service LLC · Des Arc, ARBuilt 2010 · S/N 602-1185 N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047 N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243 N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562 N121AAAg Air Inc · Matthews, MOBuilt 2020 · S/N 602-1310 N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336 N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069 N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520 N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049 N121TDRegistration Pending · Montgomery, ALRegistration pendingBuilt 1979 · S/N 78-23138 N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060 N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496 N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589 N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943 N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651 N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025 N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32 N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122 N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655 N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200 N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587 N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939 N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126 N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564 N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422 N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N126LAMurdoch Aerial Spraying LLC · Nehawka, NEBuilt 2015 · S/N 602-1261 N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113 N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055 N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127JWScott Cattle Company LLC · Burlington, COBuilt 2014 · S/N 802A-0553 N127PBGilland Ag Service LLC · Elkton, TNBuilt 2009 · S/N T65-022DC N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808 N128CMWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2020 · S/N 602-1309 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N128STJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1133 N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442

Back to AD 2016-05-13