Skip to content

Registered aircraft · 126

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:86-09-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-09-02-R2') 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:86-09-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-09-02-R2')
  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:86-09-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-09-02-R2')
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.

N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N11AD11 Eleven Hold Wings Inc · Dover, DEBuilt 1981 · S/N 22628 N127NKPerris Valley Airport Inc · Perris, CAS/N 47361 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213 N215WEInternational Trading Company Of Yukon Inc · Oklahoma City, OKBuilt 1984 · S/N 22936 N216WEInternational Trading Company Of Yukon Inc · Oklahoma City, OKBuilt 1984 · S/N 22937 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 N29SWKansas Aviation Museum · Wichita, KSS/N 21340 N306ALTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIBuilt 1983 · S/N 23066 N30MPMp Aviation LLC · Newport Coast, CAS/N 18998 N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917 N353PAAersale Inc · Coral Gables, FLS/N 20622 N370BCBcm Majestic Corp · Dallas, TXBuilt 1986 · S/N 23468 N413JGTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIBuilt 1984 · S/N 23148 N418CTMmu Aviation LLC · West Orange, NJBuilt 1988 · S/N RJ-42 N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045 N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797 N465TWSierra American Corp · Wilmington, DES/N 23465 N467TWSierra American Corp · Wilmington, DES/N 23466 N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675 N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676 N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304 N553AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53083 N556AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53086 N557ANPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53087 N558AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53088 N560AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53090 N561AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53091 N566AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49348 N572AA727x Aerospace Corp · Lewes, DES/N 49458 N573AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53092 N574AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53151 N576AAFronteraflight Holdings Inc · Dover, DES/N 53153 N581AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53158 N583AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53160 N585AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53248 N586AAAerothrust Holdings Leasing LLC · Miami, FLS/N 53249 N590AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53253 N595AAPac Blue Aerospace · Fairbanks, AKBuilt 1992 · S/N 53285 N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266 N697BJTexas Air And Space Museum Inc · Amarillo, TXS/N 47799 N7001UMuseum Of Flight Foundation · Seattle, WABuilt 1963 · S/N 18293 N706JPKalitta Equipment LLC · Ypsilanti, MIBuilt 1967 · S/N 19835 N722CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1974 · S/N 20948 N723CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1972 · S/N 20545 N726USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22469

Back to AD 86-09-02 R2