Skip to content

Registered aircraft · 22,416

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

N679TSCoco Aircraft Inc · Merritt Island, FLBuilt 1998 · S/N 2842045 N679XChagres Aero LLC · Albuquerque, NMBuilt 1977 · S/N 28R-7703101 N67DBD&R LLC · Emory, TXBuilt 1974 · S/N 28-7505096 N67DLMcarthur Narik D · Mammoth Lakes, CAS/N 28-25605 N67KTTatsumi Kurtis · Sheldon, IABuilt 1963 · S/N 28-1245 N67PLSky Point Aviation LLC · Sugar Land, TXBuilt 1967 · S/N 28-22800 N67SKMaloy Bryan K · Georgetown, TXS/N 28-4649 N67SPBird Aviation · Salt Lake City, UTBuilt 1980 · S/N 32R-8029066 N67TSBuckman William G · Bowling Green, KYBuilt 1967 · S/N 32-874 N67VFInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 288116089 N67WACapital District Pilots LLC · Slingerlands, NYBuilt 1971 · S/N 28-7125267 N6801WLaw Lewis L · Moncks Corner, SCBuilt 1965 · S/N 28-20935 N6802JHoneycutt John S · Fallbrook, CABuilt 1976 · S/N 28-7615361 N6803JGoodrich Daniel G · Cedarville, MIBuilt 1976 · S/N 28-7615362 N6803WWallace David A · Hancock, NHBuilt 1965 · S/N 28-20938 N6804JHobbs David W · Poplar Grove, ILBuilt 1976 · S/N 28-7615363 N6805J750n Aviation LLC · Mount Sterling, ILBuilt 1976 · S/N 28-7690397 N6806JVoerman Joseph R Jr · Cambridge, NYBuilt 1976 · S/N 28-7690398 N6806WWings Up LLC · Saint Augustine, FLBuilt 1965 · S/N 28-20941 N6808JHot Seat Aviation · Blacksburg, VAS/N 28R-7635335 N6808WClear Blue Aviation LLC · Melbourne, FLBuilt 1965 · S/N 28-20944 N680ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010080 N680CDFly Mnt LLC · Glenview, ILBuilt 1973 · S/N 28-7325158 N680FLSchrimpf Robert · Batesville, INBuilt 1971 · S/N 28-7125611 N680LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881230 N680TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881880 N680XLipinski Glen E · Chandler, AZS/N 28-7916431 N6810De Young Ryan · Ten Mile, TNS/N 32-7100012 N6811JRodgers Byron D III · Alexandria, VABuilt 1976 · S/N 28-7690419 N6811WKlaerner Donald John · Fredericksburg, TXBuilt 1965 · S/N 28-20947 N6812JGottschalk William R · Fort Atkinson, WIBuilt 1976 · S/N 32R-7680352 N6813WRotor And Wing LLC · Tioga, NDBuilt 1965 · S/N 28-20949 N6814JTavzel Aviation LLC · Portland, INBuilt 1976 · S/N 28-7625242 N6815JLewis Margriet · Mojave, CABuilt 1976 · S/N 28-7615364 N6816FQuality Aviation Inc · Faribault, MNBuilt 1976 · S/N 28-7715180 N6816WCabala Dennis G · Bay City, MIBuilt 1965 · S/N 28-20954 N6817JAviate LLC DBA · Hazelton, IDBuilt 1976 · S/N 28-7690400 N6817WRahz Robert D · Kirtland, OHBuilt 1965 · S/N 28-20955 N6818JSturm William · Oshkosh, WIBuilt 1976 · S/N 28-7690401 N6819JNdh Air LLC · Sunbury, OHBuilt 1976 · S/N 28-7690402 N6819WMikletich Christian E · Springfield, KYS/N 28-20957 N681ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010081 N681ATCaudullo Alfred A · Bolton, CTBuilt 1977 · S/N 32-7740038 N681DLHampton Michael D · Marshfield, MOBuilt 1965 · S/N 32-178 N681JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020081 N681LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881231 N681TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881881 N6822WAjf Enterprises LLC · Des Moines, IAS/N 28-20960 N6823WThomas Kevin A · Selbyville, DEBuilt 1965 · S/N 28-20961 N6824JMorrison Justin Gregory · Houston, TXBuilt 1976 · S/N 28-7625243

Back to AD 87-08-08 R3