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.

N3310RSeitz Martin V · Brookfield, WIBuilt 1967 · S/N 18258610 N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310 N3311DPendergrass Joseph M · Wasilla, AKBuilt 1955 · S/N 32109 N3311RView From Above Inc · Columbia, CABuilt 1967 · S/N 18258611 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3311UBeck Gary · Albuquerque, NMBuilt 1963 · S/N 18254711 N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311 N3312FWill Robert J · Fall City, WABuilt 1966 · S/N 18257312 N3312RParish Mark · Earth, TXBuilt 1967 · S/N 18258612 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3312URoberts Air Inc · Goodwin, ARBuilt 1963 · S/N 18254712 N3313ULayton Robert H · Seminole, TXBuilt 1963 · S/N 18254713 N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313 N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236 N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314 N3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeBuilt 1966 · S/N 18257315 N3315RTriple X Construction Inc · Camp Verde, AZBuilt 1967 · S/N 18258615 N3316RBranstetter Jack · Ponca City, OKS/N 18258616 N3317FPeniston Mandy J · Chillicothe, MOBuilt 1966 · S/N 18257317 N3317RBanti Gustavo · Marco Island, FLBuilt 1967 · S/N 18258617 N3317USierra Aviation LLC · Fond Du Lac, WIBuilt 1963 · S/N 18254717 N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659 N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318 N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664 N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747 N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164 N331DTTolkach Dennis G · Dunlevy, PAS/N 18504238 N331GWFieldcrest Air LLC · Latrobe, PABuilt 2021 · S/N 18283147 N331LCEblc Aviation LLC · Hollywood, FLS/N U20605254 N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021 N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441 N3320DPara Tactics LLC · Shelton, WAS/N 32118 N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320 N33216Avarts LLC · New Castle, DES/N U20602676 N3321DWood Steveno · Morgan, UTS/N 32119 N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321 N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621 N3322DObrien Aviation LLC · Moreno Valley, CABuilt 1955 · S/N 32120 N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322 N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722 N3322YFostair Inc · Ovid, NYS/N 18254322 N3323DPrince Christopher E · Anchorage, AKBuilt 1955 · S/N 32121 N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323 N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623 N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323 N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692 N3324UHaer Welton · Craig, MOBuilt 1963 · S/N 18254724 N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324 N3325RDresick Farms Inc · Huron, CABuilt 1968 · S/N 18258625 N3325UWeber Donald E · Saint David, AZS/N 18254725

Back to AD 84-10-01 R1