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.

N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327 N951POncourse LLC · Miami, FLBuilt 2001 · S/N TH-2015 N9529GStart Skydiving LLC · Middletown, OHBuilt 1988 · S/N 208B0091 N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088 N952BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5201 N952CAAc Spe 3 LLC · Orlando, FLBuilt 1991 · S/N 25238 N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196 N9536PPa1 208-00090 LLC · Fort Lauderdale, FLBuilt 1986 · S/N 20800090 N9539FPa1 208-00092 LLC · Fort Lauderdale, FLS/N 20800092 N953AJS A Comunale Co Inc · Barberton, OHBuilt 2000 · S/N BB-1723 N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539 N953FAffordable Equity Partners Inc · Columbia, MOBuilt 1989 · S/N 560-0005 N953FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0062 N953JFRwb Holdings LLC · Cheyenne, WYBuilt 1984 · S/N 650-0043 N953JMAlta Airlines Holdings LLC · Salt Lake City, UTS/N 25151 N953NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33328 N953RCRmc Aviation LLC · Trumann, ARBuilt 1980 · S/N BE-94 N9546BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0126 N954ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30089 N954FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0064 N954GSGlen Sain LLC · Paragould, ARBuilt 1997 · S/N LJ-1484 N954LEBering Air Inc · Nome, AKBuilt 1993 · S/N UE-72 N954MSBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N BB-1649 N954NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31197 N954ZAZulu Air LLC · Opa Locka, FLBuilt 2000 · S/N BB-1712 N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540 N955BRBuffalo River Aviation LLC · Bentonville, ARBuilt 1972 · S/N TH-230 N955DPN955dp LLC · Wilmington, DEBuilt 1988 · S/N NA0412 N955FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0066 N955GBBioventures Leasing Corporation LLC · Brookhaven, GABuilt 1999 · S/N E-3286 N955LJTk Healthcare Management LLC · Abilene, TXS/N E-3082 N955NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31199 N955PLMjlg LLC · Nantucket, MABuilt 2023 · S/N 208B5753 N955TXLouis Jean LLC · Andrews, TXBuilt 2000 · S/N 525-0386 N955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2002 · S/N 328 N955WPAir Bc LLC · Lorena, TXBuilt 2014 · S/N FL-916 N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090 N956DUS Government · Washington, DCBuilt 2004 · S/N 208B1056 N956FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0068 N956NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31200 N956TXTexas Department Of Public Safety · Austin, TXBuilt 2014 · S/N 20800563 N9570QAbubakar Sunday · Wichita Falls, TXBuilt 1968 · S/N E-18 N957AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39957 N957ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29541 N957CBBd Air LLC · Battle Ground, WABuilt 1998 · S/N BB-1624 N957ECBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 146 N957FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0070 N957NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31202 N957PCPilot Realty Inc · Sackets Harbor, NYS/N TH-2023 N957SPSouthern Airways Pacific LLC · Addison, TXBuilt 2014 · S/N 208B5165

Back to AD 2006-16-18 R1