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.

N1290DSky Tech Inc · Dorchester, NEBuilt 2020 · S/N 602-1308 N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079 N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065 N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229 N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N129LCL R & F LLC · Dover, DEBuilt 1979 · S/N 31T7904042 N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629 N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LUDonalds Flying Service Inc · Pantego, NCBuilt 1998 · S/N T15-037DC N130BMBoyds Aviation LLC · Rayville, LABuilt 2006 · S/N 802A-0249 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N131LAThompson Flying Service LLC · Charleston, MOBuilt 2024 · S/N 802-1132 N131SAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 46020113 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N1323RWright Air Service Inc · Fairbanks, AKBuilt 1999 · S/N 208B0745 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777 N132JWLowry Flying Service Inc · Grinnell, IABuilt 2008 · S/N 602-1156 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169 N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032 N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776 N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135 N135LTFleming William D · Litchfield, ILBuilt 1997 · S/N 135 N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551 N136CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0037 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N138JMFull Throttle Aviation LLC · Clayton, DEBuilt 1991 · S/N 7 N139MCBilly Bobs Flying Service LLC · Bay, ARBuilt 2024 · S/N 510-139 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13GXEpic II LLC · Reno, NVBuilt 2023 · S/N K040 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140 N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465 N1421ZMng Leasing LLC · Bottineau, NDBuilt 1998 · S/N 140 N142BMAll In Flying Co · Wilmington, DEBuilt 2006 · S/N 602-1142 N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612 N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437 N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49 N144JTFlight 1976 LLC · Kennesaw, GABuilt 1999 · S/N 144 N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640 N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667 N145LADakota Air Spray LLC · Huron, SDBuilt 2006 · S/N 602-1145 N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046

Back to AD 2016-05-13