Skip to content

Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N5525FCashion Thomas A · Mastic, NYBuilt 1968 · S/N 28-24866 N5525KMacomber Donald Conrad · Santa Ynez, CABuilt 1978 · S/N 1025-78 N55260Weich Ronald L · El Paso, TXBuilt 1973 · S/N 28-7305343 N55261Barton John S III · Gallatin, MOBuilt 1973 · S/N 28-7305344 N55263Fennell Donald H Jr · Hampstead, NCBuilt 1973 · S/N 28-7305345 N55264Ace Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 17275147 N5526FLandry Raymond L · Stark, NHBuilt 1968 · S/N 28-24867 N5526KOn-Site Aviation Inc · Hillsboro, NDBuilt 1978 · S/N 273-78 N5526MEz Breezy Fc LLC · San Diego, CAS/N 28-22539 N5526PWard County Irrigation District #1 · Barstow, TXS/N 24-589 N5526UPearl Wings LLC · Doylestown, OHBuilt 1969 · S/N 28-26242 N55270Mcconnell Jason A · Rose Hill, VABuilt 1973 · S/N 28-7325356 N55272Nienhuis Alvin Dale II · Brooksville, FLBuilt 1973 · S/N 28-7305348 N55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJBuilt 1973 · S/N 28-7305349 N55278Hackman Daniel W · Wimauma, FLBuilt 1973 · S/N 32-7300035 N5527FFarnie Christopher J · Jacksonville, FLBuilt 1968 · S/N 28-24868 N55284Winters Daniel K · Pennsburg, PABuilt 1973 · S/N 28-7325359 N5528RVroom Brian D · Tucson, AZS/N 172RG0071 N55291Riverside Flight Academy LLC · Riverside, CABuilt 1981 · S/N 17275152 N55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEBuilt 1981 · S/N 17275154 N5529FKeiner Larry E · Drums, PABuilt 1968 · S/N 28-24871 N5529QWhipple Ron · Etna, CABuilt 1965 · S/N 2953 N5529UStoll Travis · El Dorado Springs, MOBuilt 1969 · S/N 28-26245 N5529WHarvey Gregory D Sr · Greenbush, MEBuilt 1962 · S/N 28-623 N552LELeading Edge Flight Academy LLC · Bend, ORBuilt 2003 · S/N 3502 N552MDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 447995008 N552PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842089 N55301Registered aircraftBuilt 1973 · S/N 28-7325361 N55302Coastl Air Inc · Groton, CTBuilt 1973 · S/N 28-7325362 N55303Cullum Phillip R Jr · San Tan Valley, AZBuilt 1973 · S/N 28-7325363 N55304Brittle Aviation LLC · Chapel Hill, NCBuilt 1973 · S/N 28-7305353 N55305Berry Mitchel R · Chatfield, MNBuilt 1973 · S/N 28-7305354 N5530WHobgood Sidney · Klamath Falls, ORBuilt 1962 · S/N 28-621 N55310Monarch M Miller · Cloverport, KYBuilt 1973 · S/N 28-7325364 N55311Aeras Transport LLC · Lewes, DEBuilt 1973 · S/N 28-7305355 N55313Dunning Mark · Chino Hills, CABuilt 1973 · S/N 28-7305357 N55315Norman Eric Lee · Hilton Head Island, SCBuilt 1973 · S/N 28-7305359 N5531FSchmidt David D · Atlantic Mine, MIBuilt 1968 · S/N 28-24874 N55320Dragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 1981 · S/N 17275157 N55325Hater Michael A · Cincinnati, OHBuilt 1981 · S/N 17275158 N55327Grise Paul R · Hopkinsville, KYBuilt 1973 · S/N 28-7305362 N5532UGorman Jeremy J · Chapman, KSBuilt 1969 · S/N 28-26249 N55338Pt Arts LLC · Grand Rapids, MIBuilt 1973 · S/N 28-7325370 N5533FCopenhaver Ralph L · Brady, TXBuilt 1968 · S/N 28-24876 N5533QBoldt Matthew Frederick · Santa Fe, NMBuilt 1965 · S/N 2955 N5533RThompson Aaron R · Louisville, KYS/N 172RG0072 N55340Air55 LLC · Charleston, WVBuilt 1973 · S/N 28-7305363 N55342Dienwiebel Thomas · Santa Cruz, CAS/N 1183 N55349Mob Aviation LLC · Auburndale, FLS/N 17275163 N5534ELindsey Kelly M · Throckmorton, TXBuilt 1978 · S/N 17271883

Back to AD 80-04-03 R2