Registered aircraft · 56,580

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.

N3866QOcala Aviation Services Inc · Ocala, FLBuilt 1971 · S/N 17259966 N3866SKnutson Steven O · Wickenburg, AZBuilt 1963 · S/N 17251066 N3866YMessina Jacob · Copley, OHBuilt 1964 · S/N 21058366 N3867CKrmo Aviation LLC · Duluth, MNFirst renewal noticeBuilt 1954 · S/N 31015 N3867DPrestige Air Worldwide LLC · Seneca, SCBuilt 1957 · S/N 34567 N3867JOmura Alexander K · Missoula, MTBuilt 1966 · S/N 15065167 N3867LDorsey Levi Rondall · Demorest, GABuilt 1965 · S/N 17254036 N3867QLangner Dale R · Louisburg, KSBuilt 1971 · S/N 17259967 N3867RHowser Timmy L · Batavia, OHBuilt 1966 · S/N 17255367 N3867SMakee Markus J · Painesville, OHBuilt 1964 · S/N 17251067 N3867VMurat Armand · Granger, INBuilt 1949 · S/N 18754 N3867YGallagher Robert B · Rio Oso, CABuilt 1964 · S/N 21058367 N3868DRegistered aircraftBuilt 1957 · S/N 34568 N3868QLibbys Sporting Camps Inc · Chapman, MEBuilt 1973 · S/N 18502205 N3869DOwens Hay LLC · Crane, ORBuilt 1957 · S/N 34569 N3869QNew Garden Township · Landenberg, PABuilt 1971 · S/N 17259969 N3869RErl Don L · Medford, WIBuilt 1966 · S/N 17255369 N386CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283344 N386EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12912 N386ESJet Air Inc · Iowa City, IABuilt 1997 · S/N 17280106 N386MEHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8583 N386SPUsaf Academy Aero Club · Usaf Academy, COBuilt 1999 · S/N 172S8283 N3870DKlad-Air LLC · Catlett, VABuilt 1957 · S/N 34570 N3870JLucido Frank · Vacaville, CABuilt 1966 · S/N 15065170 N3870LStraub Brian L · Queensbury, NYBuilt 1965 · S/N 17254039 N3870QLake Waccamaw Aviation LLC · Lake Waccamaw, NCBuilt 1971 · S/N 17259970 N3870SCherryhill Aviation Inc · Freetown, INBuilt 1963 · S/N 17251070 N3870VMercury International LLC · Cheyenne, WYBuilt 1977 · S/N R1722266 N3872LMaletich Steven J · Las Vegas, NVBuilt 1965 · S/N 17254041 N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972 N3872RS&Sa Aviation LLC · Colby, KSBuilt 1966 · S/N 17255372 N3872SNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17251072 N3873GKronfuss Edward P · Bozeman, MTBuilt 1967 · S/N U206-0873 N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973 N3873RFoster William G Jr · Sunnyvale, CABuilt 1966 · S/N 17255373 N3874GMcfarlane Bradley J · Port Alsworth, AKS/N U206-0874 N3874RMartig Glenn A · Lino Lakes, MNBuilt 1966 · S/N 17255374 N3875DJames D Wirt · Goldsby, OKBuilt 1957 · S/N 34575 N3875GBurnett Ross L · Riggins, IDBuilt 1967 · S/N U206-0875 N3875LBazemore Robert J · Butler, GAS/N 17254044 N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975 N3875SFlying M Enterprises · Loomis, NEBuilt 1963 · S/N 17251075 N3875UCody Plane Corp · Wilmington, DEBuilt 1964 · S/N 336-0175 N3875VBlaedow Kyle R · North Pole, AKBuilt 1975 · S/N 15076643 N3876DBurns William Greg · Eloy, AZBuilt 1958 · S/N 34839 N3876LWoerle Edward R · Rossville, TNS/N 17254045 N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976 N3876RTriple Farms DBA · Sikeston, MOBuilt 1966 · S/N 17255376 N3876SMustoe William J Jr · Summersville, WVBuilt 1963 · S/N 17251076 N3876VKramer William L · Big Lake, AKBuilt 1981 · S/N 18504167

Back to AD 79-10-14 R1