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.

N1528XAldrich Air Transport LLC · Saint Augustine, FLBuilt 1975 · S/N 28-7515417 N15298Gcs Aviation Services LLC · Fleming Island, FLBuilt 1973 · S/N 28-7425001 N15299Dogra Gaurav · Madison, WIBuilt 1972 · S/N 28-7305051 N1529JDemmin Rama G · Alto Pass, ILBuilt 1967 · S/N 28-23928 N1529RBall Chad M · Delaware, OHBuilt 1975 · S/N AA5B-0029 N152DCTms Aviation LLC · Massapequa, NYBuilt 2001 · S/N 2842140 N152LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842195 N152MNauleau Paul Elie · San Francisco, CABuilt 1952 · S/N 25006 N1530JCountry Club Mortgage LLC · Grain Valley, MOBuilt 1967 · S/N 28-23929 N15310N15310 LLC · Alexandria, VABuilt 1972 · S/N 28-7325035 N15311Johnson Darin Charles · Wells, MNBuilt 1972 · S/N 28-7305055 N15319Merchant Jerry J · Bogata, TXBuilt 1972 · S/N 28-7325037 N1531JPerception Prime LLC · Beverly, MABuilt 1967 · S/N 28-23931 N1531RMorgan Virginia K · Artesian, SDBuilt 1975 · S/N AA5B-0031 N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648 N15322Ofner Josef P · Canterbury, NHBuilt 1972 · S/N 28-7305056 N15323Coastal Flight Inc · Tierra Verde, FLBuilt 1972 · S/N 28-7305057 N15327Carey Nicholas Andrew · Glencoe, ILBuilt 1972 · S/N 28-7325040 N1532JRosario Pamela Peralta · Orlando, FLBuilt 1967 · S/N 28-23932 N1532RAdkins Todd D · Manassas, VABuilt 1975 · S/N AA5B-0032 N1533JTolmachoff Alex W · Rogers, TXBuilt 1967 · S/N 28-23933 N1533RAnderson Michael · Byhalia, MSBuilt 1975 · S/N AA5B-0033 N1533XBurkhardt Stacie M · Wasilla, AKBuilt 1975 · S/N 28-7505240 N15343Bridger'S Hvac And Welding LLC · Milan, TNBuilt 1972 · S/N 28-7305061 N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038 N1534JChapman Melvin Newton II · Mishawaka, INBuilt 1967 · S/N 28-23934 N15354Stephen Swift · Justin, TXBuilt 1972 · S/N 28-7305062 N15359Kobberdahl Matthew T · Maple Grove, MNBuilt 1972 · S/N 28-7325046 N15360Registered aircraftBuilt 1972 · S/N 28-7325047 N15361Williams Darren M · Carthage, ILBuilt 1972 · S/N 28-7305063 N15367Labrousse Ronald E · Tidewater, ORBuilt 1972 · S/N 28-7325048 N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036 N15372Hollingshead Terry L · Flint, MIBuilt 1972 · S/N 28-7325050 N15373Johnson Brant T · Collinsville, OKS/N 28-7325051 N15376Brown William D Jr · Mount Pleasant, TXBuilt 1972 · S/N 28-7305065 N15377Johnson Matthew · Biglerville, PABuilt 1972 · S/N 28-7305066 N15378Ketcham Jesse E · Aguanga, CABuilt 1973 · S/N 28-7305067 N1537JYearta Philip T · Bono, ARS/N 28-23938 N1537XSale Reported · Milton, FLSale reportedBuilt 1975 · S/N 28-7515418 N15388Smith John-Michael L · Austin, TXBuilt 1972 · S/N 28-7325054 N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038 N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N15391Lyon Anthony R · Bethesda, MDBuilt 1972 · S/N 28-7305068 N15392Dgm Aviation LLC · Hurricane, WVBuilt 1972 · S/N 28-7305069 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N153AMMedford Daniel E · Lakeville, MNS/N 17702222 N153BAGeorge Tim D · Cleburne, TXBuilt 2010 · S/N 880211 N153BCMeierotto Jeff T · Two Rivers, AKBuilt 2011 · S/N BC-1 N153CHarless Richard K · Battle Mountain, NVBuilt 1998 · S/N 1415 N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753

Back to AD 80-04-03 R2