Registered aircraft · 661

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:84-10-06-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:84-10-06-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:84-10-06-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:84-10-06-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:84-10-06-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:84-10-06-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.

N87XCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 441-0133 N880ACN880ac LLC · Hastings, MIBuilt 1982 · S/N 1559SA N880GGarlynson Airways LLC · Lincoln, NEBuilt 1980 · S/N 95033 N88692Conquest Aircraft Leasing LLC · Carlsbad, CABuilt 1982 · S/N 441-0290 N887SDTesoro Capital LLC · High Point, NCBuilt 1984 · S/N 96207 N888SEAir 1st Inc · Aiken, SCBuilt 1982 · S/N 1549 S.A.N888WWVictory Aviation LLC · West Palm Beach, FLBuilt 1980 · S/N 791 S.A.N88GWWav Series LLC · Batavia, ILBuilt 1980 · S/N 441-0187 N88QTOrthoairways LLC · Westlake, TXBuilt 1981 · S/N 441-0228 N892SCDrs Sandra M Krokos And Thomas P Kislan Pc · Drums, PABuilt 1979 · S/N 392 S.A.N892WATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 11273 N893KBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 415SA N8970NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 441-0092 N89DRN89dr LLC · Lowell, ARBuilt 1978 · S/N 713SA N89SCKcb Air LLC · Pendleton, INBuilt 1981 · S/N 1516 S.A.N8PQElkhorn Aviation Inc · Baker City, ORBuilt 1975 · S/N 11243 N901MCMs Merlin LLC · Dallas, TXS/N T369 N901TECheviot Holdings LLC · Key Largo, FLBuilt 1983 · S/N 15031 N905AAGraber Joel C · Collins, MSS/N TK65 N907PASale Reported · Aurora, ORSale reported, canceledBuilt 2013 · S/N A6500003SC N907VMVmo LLC · Anchorage, AKS/N 1569SA N9089VWorld Class Aviation Inc · Peachtree City, GABuilt 1994 · S/N DC862M N909FSMj Aviation Inc · Walnut Ridge, ARBuilt 1995 · S/N G6-123 N910NFAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1973 · S/N 623 N911KCCounty Of Kern · Bakersfield, CABuilt 1975 · S/N 11300 N911XZSimmons & Associates · Hayward, CABuilt 2008 · S/N 0001 N913NL2242 Enterprises LLC · Dover, DES/N 15008 N9152XSchoenau Michael DBA · Tulare, CAS/N 1Z026-30 N915HAHeritage Ag LLC · Lakeview, MIBuilt 2013 · S/N G10-176 N916SJConquest Aviation LLC · Las Vegas, NVBuilt 1981 · S/N 441-0243 N91BFPlatinum Storage Properties LLC · Wayzata, MNBuilt 1981 · S/N 441-0245 N922HPColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1978 · S/N 441-0027 N937BBBravo Air LLC · Morristown, TNS/N 441-0248 N947LMAltisimo LLC · West Palm Beach, FLBuilt 1982 · S/N 15015 N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98 N94EA63nl LLC · Willmar, MNBuilt 1985 · S/N 96094 N950MD5-T Aviation LLC · Eunice, LABuilt 1981 · S/N AT-452B N957ARBrunet Pedro A Rubio · Mulberry, FLBuilt 1980 · S/N TC-371 N95ABRidgeaire Inc · Jacksonville, TXS/N 96012 N961BWConstruction Helicopters LLC · Howell, MIS/N 248 N969PMMorris Ag Air & Sons Inc · Orovada, NVBuilt 1977 · S/N 5088R N969TDThompson Builders Corp · Novato, CABuilt 1983 · S/N 15032 N977MPMartins Famous Pastry Shoppe Inc · Chambersburg, PABuilt 1983 · S/N 441-0310 N980AETj Air Holdings Inc Trustee · Wilmington, DEBuilt 1981 · S/N 95078 N980CWWells & West Inc · Murphy, NCS/N 95013 N980EEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 95039 N9853Oregon Trail Air Service LLC · Nyssa, ORBuilt 1974 · S/N 1291 N989SBConquest Shares LLC · Liberal, KSBuilt 1979 · S/N 441-0089 N98EBAspen Helicopters Inc · Oxnard, CABuilt 1980 · S/N T-332 N98PJPia Avcenter LLC · Peoria, ILBuilt 1976 · S/N 11320

Back to AD 84-10-06 R1