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.

N958AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39958 N958ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30091 N958CCSolomon Mark Trustee · Wilmington, DEBuilt 1989 · S/N TH-1565 N958FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0071 N958GBHawkeye Asset Management & Consulting Services LLC · Kilgore, TXBuilt 2004 · S/N 560-0680 N958HCHydroair LLC · Auburn, ALBuilt 1999 · S/N TH-1891 N958JHAims Community College · Greeley, COS/N LJ-1108 N958JLEuroaviation Inc Trustee · KematenBuilt 2024 · S/N 20800712 N958MGMgi Air Inc · Dubuque, IABuilt 2013 · S/N 525-0805 N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203 N958SPSouthern Airways Pacific LLC · Addison, TXBuilt 2014 · S/N 208B5132 N958TPT&K Aviation LLC · Carrizo Springs, TXBuilt 1988 · S/N FA-172 N958WDBrush Art Corp · Downs, KSBuilt 1999 · S/N TH-1928 N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828 N959BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60959 N959FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0073 N959HMJavelina Aviation LLC · Cheyenne, WYBuilt 1993 · S/N 525-0047 N959NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33329 N959PPHighlands Group LLC · Lahaina, HIBuilt 1989 · S/N 029 N959WERangeflyers Inc Trustee · Wichita, KSBuilt 2026 · S/N 208B5959 N95ABRidgeaire Inc · Jacksonville, TXS/N 96012 N95AJAvnuts LLC · Pawleys Island, SCBuilt 1978 · S/N E-1254 N95ARPfaff Ben J · Bend, ORBuilt 1962 · S/N 500A-1270-93 N95BSSbp Aviation LLC · Midland, TXBuilt 2018 · S/N FL-1144 N95CLAircraft Structures International Corp · Enid, OKBuilt 1989 · S/N 208B0187 N95DTDtt Holdings LLC · Kalispell, MTBuilt 2021 · S/N 525-1099 N95GADrco Aviation LLC · Matthews, MOBuilt 1993 · S/N BB1467 N95GMMeinig High Club LLC · Klamath Falls, ORBuilt 1980 · S/N 421C0821 N95JHKab300fl9 LLC · Lewes, DEBuilt 1990 · S/N FL-9 N95JXAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1985 · S/N 6500068 N95KMAerial Logistics LLC Trustee · Lakeland, FLBuilt 1981 · S/N TH-1315 N95LBTate James D · Christiansted, VIS/N LW-24 N95LMT L Irrigation Co · Hastings, NES/N BB-1956 N95PCCapcitcur Properties LLC · Youngsville, NCS/N LJ-1109 N95PJMoghimi Gholamali · Monroe, LABuilt 1980 · S/N TH-1162 N95PNM&B Aviation Services LLC · Wilmington, DEBuilt 1972 · S/N TH-282 N95RJBlue Heron Aviation LLC · Orwigsburg, PABuilt 2021 · S/N FL-1264 N95RRKentucky Oil And Refining Co · Betsy Layne, KYBuilt 1974 · S/N E-541 N95SSDeuce Aviation LLC · Valley Mills, TXBuilt 1999 · S/N 560-0509 N95TDMahato Enterprises LLC · Boca Raton, FLBuilt 1991 · S/N 560-0110 N95TTKelly Air LLC · Cedar Falls, IABuilt 1981 · S/N BB-917 N95UPOehmig Aviation LLC · Chattanooga, TNS/N 258639 N95UTPacificorp · Portland, ORBuilt 2001 · S/N BB-1759 N9602FDodson Intenrational Parts Inc · Rantoul, KSBuilt 1985 · S/N 20800103 N960ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29542 N960FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0075 N960HLCaravan-International Leasing Inc · Carson City, NVBuilt 1991 · S/N 208B0251 N960JPElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1983 · S/N BB-1163 N960NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33330 N9612BAvion Capital Corp · Anchorage, AKBuilt 1988 · S/N 208B0136

Back to AD 2006-16-18 R1