Skip to content

Registered aircraft · 20,481

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.

N9047MOlsen Scott · Forest Lake, MNBuilt 1970 · S/N 18052147 N9047XKelley Ronald C · Deer Lodge, MTBuilt 1961 · S/N 18253447 N9048MFurber David E · Anchorage, AKBuilt 1970 · S/N 18052148 N9048TNardi Greg · Missoula, MTS/N 52948 N9048XK Fortner LLC · San Marcos, TXFirst renewal noticeBuilt 1961 · S/N 18253448 N9049CLanese Matthew N · New Milford, CTBuilt 1954 · S/N 31097 N9049GSmokey Bay Air Inc · Homer, AKBuilt 1977 · S/N U20603795 N9049MPrivate Aero Group LLC · Wilmington, DEBuilt 1970 · S/N 18052149 N9049TMeszaros David · Nashport, OHBuilt 1960 · S/N 52949 N904BPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 18052595 N9050GOneal Gary L · Springdale, ARBuilt 1971 · S/N 18260590 N9050XClassy Cockpits LLC · Ham Lake, MNBuilt 1961 · S/N 18253450 N9051GMid Continent Aircraft Corp · Hayti, MOBuilt 1971 · S/N 18260591 N9051MGrant Rory C · Lincoln, NHBuilt 1970 · S/N 18052151 N9052MJones Victor E · Cordova, AKBuilt 1970 · S/N 18052152 N9053CGuthrie Matt W · Corrales, NMBuilt 1978 · S/N R18200380 N9053XI Buy U Fly LLC · Prescott Valley, AZBuilt 1961 · S/N 18253453 N9053ZTjossem Martin O · Paullina, IAS/N 18053143 N9054CDunlap Joseph A · Brainerd, MNBuilt 1978 · S/N R18200381 N9054MMuxworthy Neil W · Hamilton, TXBuilt 1970 · S/N 18052154 N9054NBement Bob H · Vale, ORBuilt 1959 · S/N 51716 N9054XKnowles Charles M Jr · Chapmanville, WVBuilt 1961 · S/N 18253454 N9054ZAeronautical Educational Foundation · Stockton, CABuilt 1951 · S/N 7819 N9055CBison Aero LLC · Kalispell, MTBuilt 1978 · S/N R18200382 N9055MVincent Flying Service Inc · Kaplan, LABuilt 1970 · S/N 18052155 N9056MGlasscock David M · Matthews, NCBuilt 1977 · S/N 21062055 N9056TMowbray Carmine Trustee · Polson, MTBuilt 1960 · S/N 52956 N9057MUnderhill James F · Charleston, WVBuilt 1976 · S/N 18264658 N9057SMedical Supply X LLC · Coats, NCS/N 21065009 N9058TJlp Equipment LLC · Anchorage, AKBuilt 1960 · S/N 52958 N9058XSouthern Skies Aviation Inc · Cedar City, UTBuilt 1960 · S/N 18253458 N9059GElevated Aviation LLC · West Plains, MOBuilt 1971 · S/N 18260599 N9059MMortvedt Arthur D Trustee · Manley Hot Springs, AKBuilt 1970 · S/N 18052159 N9059TTwt Wings LLC · Mccall, IDBuilt 1960 · S/N 52959 N9059XHunt William E Jr · San Jose, CABuilt 1961 · S/N 18253459 N905BWMauro William J · Lancaster, CABuilt 1968 · S/N 21059033 N9060GWalther Newell A · Wasilla, AKBuilt 1971 · S/N 18260600 N9060MAshland Jeffrey C · Spirit Lake, IABuilt 1976 · S/N 18264659 N9060XLattin Travis W · Beloit, KSBuilt 1960 · S/N 18253460 N9061XSmithhart James R · Normandy Park, WABuilt 1961 · S/N 18253461 N9062MKissee Dale D Trustee · Chugiak, AKBuilt 1970 · S/N 18052162 N9063XGregory Larry C Trustee · Farmington, MOBuilt 1961 · S/N 18253463 N9064GEvans Brandon Ks · Montgomery, ALBuilt 1971 · S/N 18260604 N9064XCherokee Three LLC · Greensboro, NCBuilt 1961 · S/N 18253464 N9064ZCarranza Matthew J · Casa Grande, AZBuilt 1956 · S/N 32275 N9065MWillecke Donald K · Punta Gorda, FLBuilt 1976 · S/N 18264662 N9065TBarker Adam W · Mendota, VAS/N 52965 N9066MHarbison Laura L · Redlands, CABuilt 1976 · S/N 18264663 N9066TVertical Investment Strategies LLC · Mesquite, NVBuilt 1960 · S/N 52966 N9066XSkyskaters LLC · Portland, ORBuilt 1961 · S/N 18253466

Back to AD 84-10-01 R1