Registered aircraft · 11,797

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

N130UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0814 N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590 N1313WSecond Kitchen LLC · Chicago, ILBuilt 1979 · S/N E-1440 N1314XWright Air Service Inc · Fairbanks, AKBuilt 2008 · S/N 208B1314 N1316RAirgo Partners LLC · Lititz, PABuilt 1968 · S/N E-125 N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654 N131CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0019 N131HPPacific Integrated Handling Inc · Tacoma, WABuilt 1981 · S/N 31T-8166018 N131KGKa131kg LLC · Knoxville, TNBuilt 2018 · S/N FL-1131 N131PGAga Aviation LLC · Lewes, DEBuilt 1986 · S/N 650-0126 N131PLPd Aero LLC · Oronogo, MOBuilt 1994 · S/N 525-0057 N131RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B-0851 N131RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 560-0366 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N131UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0815 N13227United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28788 N1323RWright Air Service Inc · Fairbanks, AKBuilt 1999 · S/N 208B0745 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N13248Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28808 N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777 N1327JAbsolute Altitude LLC · Bellefontaine, OHBuilt 1993 · S/N 525-0009 N132CESouthern Energy Transport LLC · Shelbyville, TNBuilt 1995 · S/N 650-7061 N132FBRock Rivers Bancorp · Rock Rapids, IABuilt 1975 · S/N E-700 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N132NFlying Cowboys LLC · Merced, CAS/N BB-1053 N133EMWheels Up LLC · Lincoln, NES/N E-517 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N133GLHs Air LLC · Little Rock, ARBuilt 1993 · S/N 525-0001 N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697 N133MGolden Age Flight Museum · Bakersfield, CAS/N D-557 N133RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B0840 N133SCValiar Limited Company Trustee · Casper, WYBuilt 1979 · S/N 5010131 N133UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0816 N1344LU S Army · Redstone Arsenal, ALBuilt 2024 · S/N FL-1344 N1346KU S Army · Redstone Arsenal, ALBuilt 2025 · S/N FL-1346 N1349KU S Army · Redstone Arsenal, ALBuilt 2025 · S/N FL-1349 N134CJSkyview LLC · Wilmington, DES/N 134 N134UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0817 N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868 N1351KU S Army · Redstone Arsenal, ALBuilt 2025 · S/N FL-1351 N1357KTextron Aviation Inc · Wichita, KSBuilt 2025 · S/N FL-1357 N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112 N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036 N135CCCc Aviation Partners LLC · Miami, FLBuilt 2019 · S/N 208B5510 N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776 N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816 N135MKRio Frio Leasing Co LLC · Houston, TXBuilt 1984 · S/N FA-3 N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551

Back to AD 2006-16-18 R1