Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

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 N224ACSellers Scott R Trustee · Racine, WIBuilt 1978 · S/N R18200272 N224ALAirborne Support Group LLC · Marion, MTBuilt 1963 · S/N 2050342 N224CHMadden Jeffrey M · Queensbury, NYBuilt 1976 · S/N 18503075 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 N224MBBarker Ballard M · Satellite Beach, FLBuilt 1976 · S/N 177RG0935 N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089 N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016 N224PTLee Mark W · Blaine, MNS/N 18265572 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 N2251TGardner Bryan T · Rancho Cucamonga, CABuilt 1977 · S/N R18200007 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 N22556Rawareo LLC · Warsaw, MOS/N 15068359 N22558Lilik Dennis A · Lewes, DEBuilt 1968 · S/N 15068360

Back to AD 87-20-03 R2