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.

N4599BAgua Viva Ministries · Mebane, NCBuilt 1954 · S/N 614 N459CCLemon James M · Billings, MTBuilt 1971 · S/N 18501916 N459MLKon Air LLC · River Ridge, LABuilt 2015 · S/N 18282369 N459THHlavaty Troy Edward · Columbus, NEBuilt 1980 · S/N 18267544 N45AMThornburg Rocky R · White Hall, ARBuilt 1964 · S/N 21058475 N45CSSadowski Curtis D · Taylorville, ILBuilt 1958 · S/N 51391 N45ERWindmark Ridge LLC · Port Saint Joe, FLBuilt 2004 · S/N 18281498 N45KJAvondoglio Kirk D · Andover, NJS/N 33005 N45LLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1966 · S/N 18257144 N45VCHoyos Luis F · Fort Pierce, FLBuilt 1964 · S/N 21058282 N45WBDfw Aero Mechanix Inc · Oak Point, TXBuilt 1960 · S/N 50748 N45WCClark John A · Louisville, MSBuilt 1975 · S/N 18263673 N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495 N4600BKlyde Jeremy M · Irvine, CABuilt 1955 · S/N 31498 N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789 N4601BArnavair LLC · Pearland, TXBuilt 1955 · S/N 31499 N4601ETen Two Holdings LLC · Somers, MTBuilt 1982 · S/N 18268248 N4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1983 · S/N 21064790 N4602WBrugueras Ralph Steven · Deer Park, WABuilt 1963 · S/N 18254662 N4603BMonroe Frank B · Reno, NVBuilt 1955 · S/N 31501 N4604QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 21059504 N4605FSterling Aviation2 Lllc · Boca Raton, FLBuilt 1966 · S/N P206-0205 N4605QRichs Air Service · Victoria, KSBuilt 1971 · S/N 21059505 N4605UAir Dusters Inc · Roggen, COBuilt 1963 · S/N 18051305 N46063Low Thomas A Trustee · Derry, NHBuilt 1973 · S/N 18052395 N4607F7 Fox LLC · Eugene, ORBuilt 1966 · S/N P206-0207 N4607QSerrano Lynn A · Casa Grande, AZBuilt 1971 · S/N 21059507 N4607UBlack Spruce Aviation LLC · Hermon, MES/N 30251 N4608CTrinity Property Management LLC · Corvallis, ORS/N 21063572 N4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLBuilt 1966 · S/N P206-0208 N4609UJerden Corp · Overland Park, KSBuilt 1979 · S/N U20605000 N460AHensley Scott · Elbert, COS/N 7553 N460CBScott Ts Ag-Flyin Inc · Colquitt, GABuilt 1966 · S/N P206-0206 N460WPoling Barry · Texline, TXBuilt 1965 · S/N 18256773 N4610AHorn Paul · Kodiak, AKBuilt 1955 · S/N 32208 N4610BHuber Gregory A · Medina, OHBuilt 1955 · S/N 31508 N4611FRandall Jason · Woodstock, ILBuilt 1966 · S/N P206-0211 N4612BBenson Ian M · Portland, ORBuilt 1955 · S/N 31510 N4612UBauman Raymond S · Douglas, WYS/N 18051312 N4613BSutter Richard J · Kooskia, IDBuilt 1955 · S/N 31511 N4615XWaters Aero-Marine Inc · South Thomaston, MEFirst renewal noticeBuilt 1979 · S/N U20605513 N4616BHammond Russell E · La Jolla, CABuilt 1955 · S/N 31514 N4616CSan Angelo Aero L L C · San Angelo, TXS/N 21063576 N46173Wieckowski Jan M · Grand Island, NYBuilt 1973 · S/N 18052404 N4617BTevlin Neal · Saint Regis, MTBuilt 1955 · S/N 31515 N4617CBrookhaven Corp · Buffalo, NYS/N 21063577 N4617EState Of Michigan · Lansing, MIBuilt 1982 · S/N 18268251 N4617SDelange Burke G · Scottsdale, AZBuilt 1979 · S/N R18201356 N4618BRegistered aircraftBuilt 1955 · S/N 31516 N4619ARegistration Pending · Bakersfield, CARegistration pendingBuilt 1956 · S/N 32217

Back to AD 84-10-01 R1