Skip to content

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N2154DBurton Nicholas D · Clinton, TNBuilt 1953 · S/N D-3504 N2156DMoles Timothy E · New Cumberland, WVS/N D-3506 N215BPfeffer David J · Mccook, NEBuilt 1956 · S/N D-4581 N215BFWiederhoeft Dustin L · Fairmont, MNBuilt 1964 · S/N D-7665 N215MWLutz Barry · Brookshire, TXBuilt 1956 · S/N D-4797 N215QSooter Craig A · Sedgwick, KSS/N D-7600 N215SMahoney Christopher P · Quakertown, PABuilt 1953 · S/N D-3499 N215YHodgson Mark · Fox Point, WIBuilt 1967 · S/N D-8495 N2162DLawrence Gregory A · Lexington, KYBuilt 1953 · S/N D-3509 N2165DUllrich Arnold A · Sand Springs, OKBuilt 1953 · S/N D-3512 N2166DAviation Services Of Tn · Sparta, TNS/N D-3513 N216PCUnruh James L · White Rock, NMBuilt 1963 · S/N D-7153 N2173DLimitless Horizons Sevierville LLC · Sevierville, TNS/N D-3520 N2178DAir Werks LLC · Fenton, MIBuilt 1953 · S/N D-3525 N217AAMoore Augustus Shine · Denver, COBuilt 1959 · S/N D-6004 N217PSAnderson Jeffrey A · Runaway Bay, TXBuilt 1955 · S/N D-4109 N217QLasc Aviation Inc · Callaway, FLBuilt 1964 · S/N D-7680 N2180DKent James · Somerton, AZBuilt 1953 · S/N D-3548 N2182DSchroeder Dorothy Louise · Milton Freewater, ORBuilt 1953 · S/N D-3529 N2185DHamilton Gene A · Lockhart, TXS/N D-3532 N2186DStevens Neil Richard · Moravia, NYBuilt 1953 · S/N D-3533 N2187DDavenport Joshua Troy · Roper, NCBuilt 1953 · S/N D-3534 N2189DHoover Michael B · Ridgeland, WIS/N D-3536 N2190DIntravaia Anthony J · Saint Louis, MOS/N D-3537 N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078 N2191DTips Daniel · Plano, TXBuilt 1953 · S/N D-3538 N2194DAir Repair Inc · Easton, MDBuilt 1953 · S/N D-3541 N2195DMauldin Gary W · Navajo Dam, NMBuilt 1953 · S/N D-3542 N2196DWilewski Clifford R · Freeport, ILBuilt 1953 · S/N D-3543 N2197DKaiser Aviation LLC · Newman, ILBuilt 1953 · S/N D-3544 N2199KRegistered aircraftBuilt 1951 · S/N D-2941 N219BYoungs William D Jr · Moravia, NYBuilt 1956 · S/N D-4522 N219QBoe John · Langdon, NDBuilt 1965 · S/N D-7790 N21CHSievert Stephen L Sr · Plainfield, ILBuilt 1954 · S/N D-3724 N21CNV-Tail Aero LLC · Troy, MIBuilt 1953 · S/N D-3459 N21RCChristopherson Robert J · Provo, UTBuilt 1951 · S/N D-2789 N21SHFlight Less LLC · Helena, MTBuilt 1986 · S/N D-8423 N2201LHorizon Enterprises Vne LLC · Aurora, COBuilt 1976 · S/N D-9938 N2209LOrth Duane C · San Antonio, TXBuilt 1976 · S/N D-9940 N220DKey Larry Wallace II · Early, TXBuilt 1958 · S/N D-5642 N220GBryant Tyrone L · Bigfork, MTS/N D-6657 N2217YLehmer Kenneth D Trustee · Pls Vrds Est, CABuilt 1959 · S/N D-6056 N221ABFlying Banana LLC · Onsted, MIS/N D-9064 N221BDMerrell Jacob Everette · Pace, FLBuilt 1958 · S/N D-5748 N221RFFunk Robert D · Tyler, TXBuilt 1964 · S/N D-7307 N221TLLogan Thomas D · Incline Village, NVBuilt 1964 · S/N D-7652 N222CBNiki Hankins Consulting LLC · Colorado Springs, COBuilt 1968 · S/N D-8786 N222DRGoodknight Gregory W · Nevada City, CABuilt 1967 · S/N D-8604 N222DTClipper Sky LLC · Las Vegas, NVS/N D-10130 N222SPresley Wilber L · Columbus, OHBuilt 1969 · S/N D-9008

Back to AD 94-20-04 R2