Registered aircraft · 169

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

N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N112PSFrontera Flight Holdings Inc · Dover, DEBuilt 1967 · S/N 47013 N127HPHagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1959 · S/N 33 N140SCOrbital Sciences LLC · Mojave, CABuilt 1974 · S/N 193E1067 N141WEOmega Air Inc · San Antonio, TXS/N 46661 N158CLUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 58 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957 N170PAPhoenix Air Group Inc · Cartersville, GABuilt 1965 · S/N 054 N171PAPhoenix Air Group Inc · Cartersville, GABuilt 1968 · S/N 192 N177RAUnited States Government · Fort Belvoir, VABuilt 1982 · S/N 85 N192PAPhoenix Air Group Inc · Cartersville, GABuilt 1964 · S/N 149 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N234MMWalt Disney World Co · Lake Buena Vista, FLBuilt 1963 · S/N 121 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 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 N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039 N292EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53208 N293EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53209 N294EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53210 N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211 N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212 N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213 N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066 N34HGUnited States Government · Fort Belvoir, VAS/N 34 N353PAAersale Inc · Coral Gables, FLS/N 20622 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735 N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456 N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045 N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797 N454PCOmega Air Inc · San Antonio, TXS/N 18839 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 N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315 N53993United States Government · Fort Belvoir, VABuilt 1985 · S/N 104 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

Back to AD 87-05-51