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.

N4795DStemprok Roman · Corsicana, TXBuilt 1958 · S/N 34895 N4795FClark Joseph D · Kilgore, TXBuilt 1967 · S/N P206-0395 N4795UParker Omalley Corp · Chatham, NYBuilt 1965 · S/N 18051495 N4796BHough Kenneth R · New Gloucester, MEBuilt 1955 · S/N 31694 N4796NCessna N4796n LLC · Shreveport, LABuilt 1979 · S/N 18267374 N4797UPhilbrick Rodney C DBA · Bishop, CABuilt 1979 · S/N U20605108 N4798BRegistered aircraftBuilt 1955 · S/N 31696 N4799CFlying Horse LLC · Missoula, MTBuilt 1979 · S/N 21063632 N4799DDressen Donald L · Fruitland, IDBuilt 1958 · S/N 34899 N4799NLobb David C · Fort Myers, FLBuilt 1979 · S/N 18267377 N4799UChase 13 LLC · Wilmington, DEBuilt 1965 · S/N 18051499 N479HBDouble Bar Stationair LLC · Coeur D Alene, IDBuilt 1975 · S/N U20602923 N479JLLopez Jesus D · Garfield, ARS/N 18264124 N47APAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 1983 · S/N U20606768 N47CPHibler Philip Earl · Alameda, CABuilt 1957 · S/N 32304 N47DUTomlin Trevor · Huber Heights, OHS/N 18257548 N47GEMcbride Michael J · Loxley, ALBuilt 1978 · S/N 18266717 N47KLSee David M · Shady Shores, TXBuilt 1947 · S/N 7053 N47KSReiland Daniel E · Spring Valley, MNBuilt 1967 · S/N 18258363 N47MBBjerke Michael · Boise, IDBuilt 1977 · S/N U20603698 N47PSPalm Springs Air Museum Inc · Palm Springs, CABuilt 1973 · S/N 18262767 N47TCWright Frank David · Sequin, TXBuilt 1975 · S/N 21061028 N47TZZilka Timothy R · Alpine, WYBuilt 1977 · S/N 18265448 N47UAleco 182 LLC · Vestavia Hills, ALBuilt 1980 · S/N R18201525 N47WZPengilly Sky LLC · Ellicottville, NYBuilt 1975 · S/N 18263911 N4800HBellings Jerry A · Neshkoro, WIBuilt 1972 · S/N 18261310 N4800UWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1963 · S/N 205-0500 N4801NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267378 N4801UMoore Douglas R · Sylvania, GABuilt 1963 · S/N 205-0501 N4802Chambers Ronald E · Fort Collins, COBuilt 1978 · S/N 18053017 N4802BJilek Ray A · Spearfish, SDBuilt 1954 · S/N 31600 N4802DCentral Pennsylvania Soaring Association Inc · Lemont, PABuilt 1958 · S/N 34902 N4802NCentral Oregon Aviation Partners LLC · Bend, ORBuilt 1979 · S/N 18267379 N4802UBlue Sky Aviation LLC · Sherwood, ORBuilt 1963 · S/N 205-0502 N4803EC180 Holdings LLC · Austin, TXS/N 18052033 N4803TValiair Lc Trustee · Casper, WYBuilt 1981 · S/N R18201770 N4803WRollins Brian D · Smithville, MSS/N 18268203 N4804Pixel King 01 LLC · Fort Worth, TXBuilt 1983 · S/N 18268321 N4804NMueller Scott · Somis, CABuilt 1979 · S/N 18267380 N4805URice Gary B · College Place, WABuilt 1963 · S/N 205-0505 N4806NGibson Ronald M · Laurel Hill, NCBuilt 1979 · S/N 18267382 N4806YCondor Aviation LLC · Hanover, NHBuilt 1980 · S/N 21064012 N48071Burns Craft LLC · Wilmington, DEBuilt 1964 · S/N 185-0705 N4807FWinkler Jeffery L · Brush, COFirst renewal noticeBuilt 1966 · S/N U206-0507 N4807LEddy Richard C · Hurricane, UTBuilt 1957 · S/N 34827 N4807PMadigan Michael · Maryville, TNS/N 18053182 N4809Miller Wade · Hot Springs, SDBuilt 1978 · S/N 18052914 N48091Krueger Luke T · Anchorage, AKBuilt 1969 · S/N 18052047 N4809DRanger Timothy R · Anchorage, AKBuilt 1958 · S/N 34909 N4809ETownsend Robert · Leavenworth, WAS/N 18053175

Back to AD 84-10-01 R1