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.

N22489Sky Walker Flight School LLC · Adrian, MIBuilt 1968 · S/N 15068314 N2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeBuilt 1968 · S/N T210-0398 N2248YDavis Christopher S · Halls, TNBuilt 1967 · S/N 17700048 N22491Yasumiishi Joy Marie Trustee · Juneau, AKS/N 15068316 N22498Evans Thomas G · Dawson, ALS/N 15068318 N22499Johnson Dale B · Steele, NDBuilt 1968 · S/N 15068319 N2249CHepburn Joseph · Towanda, KSBuilt 1953 · S/N 30549 N2249EJones Jason Parker · Fayetteville, GABuilt 1978 · S/N 17271204 N2249GDelph Timothy M · Wasilla, AKBuilt 1958 · S/N 51549 N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193 N2249YBlake Bernie E · Troy, NCBuilt 1967 · S/N 17700049 N224ALAirborne Support Group LLC · Marion, MTBuilt 1963 · S/N 2050342 N224CHMadden Jeffrey M · Queensbury, NYBuilt 1976 · S/N 18503075 N224EMFsm Aviation LLC · Edmond, OKS/N 18281350 N224HThompson Dennis P · Spokane Valley, WABuilt 1956 · S/N 32649 N224JAWingsleasing LLC · Wichita, KSBuilt 1986 · S/N 17276588 N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812 N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613 N224MBBarker Ballard M · Satellite Beach, FLBuilt 1976 · S/N 177RG0935 N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016 N224PTLee Mark W · Blaine, MNS/N 18265572 N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893 N22501Smith Dylan Lane · Oklahoma City, OKBuilt 1968 · S/N 15068321 N2250DBruce Jason W · Stone Mountain, GABuilt 1952 · S/N 20402 N2250EDover Afb Aero Club · Dover Afb, DEBuilt 1978 · S/N 17271205 N2250JLuce Frederick M · Brookshire, TXBuilt 1966 · S/N 15065450 N22515Wheeler Bret · La Grande, ORBuilt 1968 · S/N 15068329 N2251GValentine Terence S · Glennallen, AKBuilt 1958 · S/N 51551 N22523Beene Donald L · Westfield, INBuilt 1968 · S/N 15068334 N22526Staloff Jason A · Greenfield, MABuilt 1968 · S/N 15068337 N22528Hhd Aviation LLC · Hamilton, OHBuilt 1968 · S/N 15068339 N22529Rhodes Stephen D · Hendersonville, NCS/N 15068340 N2252CMickey Donald J · Albuquerque, NMBuilt 1953 · S/N 30552 N2252GRutter Eric R · Anchorage, AKBuilt 1958 · S/N 51552 N2252RStout Walt · White Hills, AZBuilt 1968 · S/N T210-0402 N2252SSpider Lips Aviation LLC · Fischer, TXBuilt 1976 · S/N 21061196 N2252TRegistration Pending · Hayward, WIRegistration pending, pending cancellationBuilt 1968 · S/N 185-1410 N2252YMeisch Robert L · Crystal, MNBuilt 1967 · S/N 17700052 N22533Regner Mark W · Danbury, CTBuilt 1968 · S/N 15068343 N22536Reep Jennifer B · Stone Mountain, GABuilt 1968 · S/N 15068345 N22537Ernst Albert S III · Buda, TXS/N 15068346 N2253CFoss David K · Anchorage, AKS/N 30553 N2253YAviation 2000 Inc · Fort Mill, SCBuilt 1967 · S/N 17700053 N22540Mcgovern Thomas F · Blue Springs, MOBuilt 1968 · S/N 15068347 N22542Apgyn And Associates Inc · Coral Springs, FLBuilt 1968 · S/N 15068349 N22544N1705r Inc · Cobb, CAS/N 15068351 N2254CCook Charles Nicholas · Lakeside, TXBuilt 1953 · S/N 30554 N2254FHudson Daryl J · Redwood Valley, CABuilt 1974 · S/N 15076160 N2254GSorrels Robert S · Starkville, MSBuilt 1958 · S/N 51554 N2254URaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280684

Back to AD 79-10-14 R1