Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N1945CWassman Dennis B · Moraga, CABuilt 1953 · S/N 26090 N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035 N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496 N1945QSmith Thomas E Jr · Chino Hills, CABuilt 1973 · S/N 177RG0345 N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045 N19463Aviation Trust Co LLC · Oklahoma City, OKBuilt 1973 · S/N 15074431 N19469Registration Pending · Summerland Key, FLRegistration pendingS/N 15074433 N1946CRegistered aircraftBuilt 1953 · S/N 26091 N1946QMoore Garrie W · Georgetown, TXBuilt 1973 · S/N 177RG0346 N1946VLeading Edge Aviation Inc · Doylestown, PABuilt 1976 · S/N R1722221 N19476Havron Dana Houston · Huntsville, ALS/N 15074438 N19477Rare Birds LLC · Yukon, OKBuilt 1973 · S/N 15074439 N19479Kunkle Bryan S · Mount Morris, NYBuilt 1973 · S/N 15074441 N1947CWillingham Emma J · Grantville, GABuilt 1953 · S/N 26092 N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037 N1947LCal Aggie Flying Farmers · Davis, CABuilt 2016 · S/N 172S11765 N1947QBailey Jr James E · Rittman, OHBuilt 1973 · S/N 177RG0347 N19480Blair Mark · Kingman, AZBuilt 1973 · S/N 15074442 N19481Majors Flying Club · Greenville, TXBuilt 1973 · S/N 15074443 N19486Beavers David Allen · Strasburg, COS/N 15074444 N1948BKc Aviation LLC · Conway, ARBuilt 1974 · S/N 177RG0564 N1948FKdrd Holdings LLC · Texas City, TXBuilt 1979 · S/N 17273038 N1948QHorsley Luther J · Midland, ORS/N 177RG0348 N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048 N194961w1 Aero LLC · Issaquah, WABuilt 1973 · S/N 15074450 N1949AReneau Tom · Midland, TXBuilt 1949 · S/N 15240 N1949CBailey John Perry · Eagle River, AKS/N 26094 N1949PEast Bay Trading Co LLC · Fairview, PABuilt 1973 · S/N 17262835 N194ARTarpley Richard · Cleveland, GABuilt 1978 · S/N 17272029 N194SESamnik Enterprises LLC · Naples, MEBuilt 1972 · S/N 17260386 N194SPFly4sp LLC · San Mateo, CABuilt 2003 · S/N 172S9459 N194THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11552 N19501Beardsley Larry N · Leavittsburg, OHBuilt 1976 · S/N 17702574 N19506Colvard Tony D · Newland, NCS/N 15074457 N19508Andelt David L · Parker, COBuilt 1973 · S/N 15074459 N1950ABuchanan Noreen E · Meridian, IDS/N 15637 N1950FAce Of Spades Aviation LLC · Las Vegas, NVS/N 17273040 N1950QSherwood Jeffrey Curtis · Cranston, RIBuilt 1973 · S/N 177RG0350 N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659 N1950VJenson Kenneth E · Modesto, CABuilt 1980 · S/N 182-67632 N1950ZStafford Branson T · Maple Hill, NCS/N 15059750 N19514N&C Enterprises LLC · Vine Grove, KYS/N 15074461 N19516Choppin Dale · Sun City, AZBuilt 1973 · S/N 15074462 N19519Gulf Niner LLC · Eagan, MNBuilt 1976 · S/N 17702575 N1951TBachmann Jochen W · Hudson, OHBuilt 1980 · S/N 185-04134 N1951XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1965 · S/N 18256051 N1951ZAnderson Zachery D · Bigfork, MTBuilt 1962 · S/N 15059751 N19520Ag Avventures LLC · Hartford, WIS/N 15074465 N19522Cannan Aviation Inc · Georgetown, TXS/N 15074467 N19523Frana Joel A DBA · Fort Myers, FLBuilt 1973 · S/N 15074468

Back to AD 79-10-14 R1