Skip to content

Registered aircraft · 40,472

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.

N34787Baker Herman L · Austin, TXBuilt 1973 · S/N 17702003 N3478KYarber Brandon Tate · Cleveland, TNBuilt 1967 · S/N 28-23573 N3478TGuzowski Richard G · Haydenville, MABuilt 1968 · S/N 17700778 N34794Schmidt Gary L · Afton, MNBuilt 1973 · S/N 17702005 N34796Masters David R · Troy, KSBuilt 1973 · S/N 17702007 N3479TRobbins Derick Mitchell Robbins · Freeport, FLBuilt 1968 · S/N 17700779 N3479ZPhegley James R · Carlisle, INBuilt 1960 · S/N 18-7308 N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661 N347DMSpivey Ricky S · Samson, ALBuilt 1997 · S/N 21803 N347ECallahan Kevin Michael · Des Moines, WABuilt 2011 · S/N 72189 N347GDNye Brian M · Independence, ORBuilt 2002 · S/N 23851 N347GWAllen Air LLC · Creola, ALBuilt 1966 · S/N 28-3651 N347RAAdamson Matthew C · Sherwood, ARBuilt 1978 · S/N 3100 N347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledS/N 28-571 N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883 N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016 N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017 N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575 N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780 N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020 N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022 N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023 N3481TEstes Kenneth · Portland, ORS/N 17700781 N3481XN3481x LLC · Reno, NVBuilt 1966 · S/N 3421 N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025 N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026 N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029 N3482THaskell Thomas Edward · Georgetown, TXBuilt 1968 · S/N 17700782 N3482XCollins Dallas · Columbia, SCBuilt 1966 · S/N 3422 N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030 N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032 N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033 N3483TCalhoun Edward J · Whitney, NEBuilt 1968 · S/N 17700783 N34845Ccf Ventures Inc · Bangor, MES/N 17702039 N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041 N3484MNiner One Aviation LLC · Hillsboro, ORBuilt 1947 · S/N 12-2080 N3484TCairo Jane LLC · Ponca City, OKBuilt 1968 · S/N 17700784 N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044 N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049 N3485ZVarco John M · Palmer, AKBuilt 1960 · S/N 18-7317 N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051 N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053 N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056 N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701 N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423 N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058 N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059 N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159 N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424 N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064

Back to AD 80-04-03 R2