Registered aircraft · 20,483

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-01-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-01-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-01-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-01-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-01-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-01-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.

N2655ZRegistered aircraftN-number assigned (import), not yet registeredS/N 185-0655 N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196 N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029 N2656QPankrate Kenneth W · Opheim, MTS/N 18257856 N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757 N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157 N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198 N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758 N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958 N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358 N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616 N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959 N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502 N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859 N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359 N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034 N265HPN265hp LLC · Parachute, COBuilt 1985 · S/N 18268519 N265MESunset Leasing Inc · Sarasota, FLBuilt 2000 · S/N 18280771 N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100 N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083 N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760 N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960 N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360 N2660YRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051160 N26613Coomes Thomas R · Hollis, OKBuilt 1998 · S/N 18280326 N26616Sea Wing LLC · Camarillo, CABuilt 1998 · S/N 18280329 N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102 N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861 N2661YAlaska Outdoor Consultants LLC · King Salmon, AKBuilt 1962 · S/N 18051161 N2662ARogers Construction Services Inc · Boca Raton, FLBuilt 1998 · S/N 18280331 N2662BGjl Aviation LLC · Fort Worth, TXBuilt 1998 · S/N 18280332 N2662FGarmin International Inc · Olathe, KSBuilt 1998 · S/N 18280337 N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962 N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162 N2662ZBidcal Inc · Chico, CABuilt 1998 · S/N 18280338 N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863 N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298 N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201 N2666GForward Logistics LLC · New Castle, VAFirst renewal noticeBuilt 1959 · S/N 51966 N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866 N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767 N2667GTundra Aviation Inc · Casselton, NDS/N 51967 N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367 N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347 N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768 N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968 N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368 N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769

Back to AD 84-10-01 R1