Skip to content

Registered aircraft · 68,369

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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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:90-04-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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.

N2432MBunce John · Canaan, CTS/N 12-1530 N2432NMastre Benjamin T · Soldotna, AKBuilt 1947 · S/N 12684 N2432PUnruh Philip Trustee · Harper, KSBuilt 1955 · S/N 22-2803 N24331Registration Pending · Norman, OKRegistration pendingBuilt 1977 · S/N 15280219 N24333Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280220 N2433ARyther John W · Austin, MNS/N 20-929 N2433FJohnson Paul · Newnan, GABuilt 1979 · S/N 38-79A0438 N2433MHarkey Aviation LLC · Sherrills Ford, NCBuilt 1977 · S/N 28-7816285 N2433NFalcon Aerolab LLC · Colorado Springs, COBuilt 1979 · S/N 38-79A0840 N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872 N24342Loma Aviation LLC · San Diego, CABuilt 1973 · S/N 287305419 N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251 N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230 N2435DThibodeau Dean U · North Pole, AKBuilt 1952 · S/N 20587 N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253 N2435PGarst William P · Johnson City, TNBuilt 1955 · S/N 22-2806 N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235 N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236 N24367Raimo Joseph H · New York, NYS/N 1703 N24369Norman John W · Burlington, WABuilt 1940 · S/N 1705 N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089 N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842 N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841 N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056 N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665 N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240 N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248 N24387Lewis Roger A · Pell City, ALBuilt 1940 · S/N 1723 N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878 N2438LHart Lewis W · Rexburg, IDBuilt 1979 · S/N 38-79A0703 N2438PDavey Kenneth E · Lake Crystal, MNBuilt 1955 · S/N 22-2809 N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622 N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875 N2438TSupp Robert W · Wells, NVBuilt 1962 · S/N NAV-4-2438 N24396Waldron Robert J Trustee · Webster, MNBuilt 1940 · S/N 1732 N24397Bryant Margaret A · Tallahassee, FLBuilt 1979 · S/N 38-79A1114 N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252 N2439MRegistered aircraftBuilt 1947 · S/N 12-1667 N2439PNeal Christopher C · Staples, MNBuilt 1955 · S/N 22-2810 N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733 N243AKHilwig Kara · Wasilla, AKBuilt 1989 · S/N 1809010 N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042 N243CMRegistered aircraftS/N 545E N243CYHarvey Steven T · Honolulu, HIBuilt 2000 · S/N 2081 N243DBMainpro Inc · Alexandria, KYBuilt 2002 · S/N 2315 N243EHVeracity Aviation LLC · Seguin, TXS/N 3482 N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113 N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019 N243JGBateman Scott R · Montrose, CABuilt 2001 · S/N 80669 N243JHFlowers Derrick W · San Antonio, TXBuilt 2016 · S/N 20454

Back to AD 90-04-06 R1