Registered aircraft · 72,010

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-10-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:87-10-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:87-10-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:87-10-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:87-10-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:87-10-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.

N4099WWilde Stephen · Elverta, CAS/N 32-40162 N4099XMiller Aviation Group LLC · Coon Rapids, MNBuilt 1971 · S/N 5199 N4099ZMayes Brett R · Williams, CABuilt 1964 · S/N 18-8113 N409AFThomas Douglas M Jr · Blue Bell, PABuilt 1966 · S/N 28-21915 N409AKHenderson Kim · Everett, WABuilt 1998 · S/N 3257072 N409CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881120 N409CCPappy Air LLC · Pickerington, OHBuilt 2023 · S/N 28020113 N409DParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020224 N409ESN409es LLC · Stuart, FLBuilt 1997 · S/N 17280231 N409FDSouth Seas Aviation Ltd · Wilmington, DEBuilt 1987 · S/N 726 N409FPAamro Aviation Corp · Lake Worth, FLNon-citizen corporation, flight hours not reportedBuilt 2006 · S/N 40.FC009 N409JBPenstar Partners LLC · Wilmington, DEBuilt 1969 · S/N 60003988 N409LAAnderson Wilma (Lori) · Blue Mound, ILS/N 24-1494 N409MMStormer Isaac E · Curtis, WABuilt 1981 · S/N 154 N409NSGonzalez John E · Malibu, CABuilt 2012 · S/N 40409 N409RWAllred Mike · Thomasville, NCBuilt 2012 · S/N RWW-3 N409TPParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020073 N409XDunn Blake · Bristol, COBuilt 1976 · S/N 7043C N409XXPope James D · Clarkston, WABuilt 2013 · S/N 001 N40ACRadecki Louis · Helenville, WIBuilt 1991 · S/N 644-91 N40ASSchaad Rene · Arroyo Grande, CABuilt 1998 · S/N 18280422 N40ATN40at LLC · Lewis Center, OHBuilt 1978 · S/N R18200527 N40AWKlingbeil Mark T · Bottineau, NDBuilt 1999 · S/N 1452 N40BXBreton Michael A · Avon Lake, OHBuilt 2004 · S/N 25771 N40BYMassengill Brad · Lowell, INBuilt 2012 · S/N 91232 N40CACharley Alpha LLC · Umatilla, FLBuilt 1980 · S/N 31-8012082 N40CBBurnett Chad H · Draper, UTBuilt 1996 · S/N 22105 N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264 N40CMKline Timothy L · Elverson, PABuilt 1987 · S/N 368 N40CRMoyer Gregg A · Haymarket, VABuilt 2015 · S/N 1003 N40CSSoloy L Chris · Wasilla, AKBuilt 1993 · S/N 1 N40CVDos Vidas Services Inc · Seabrook, TXBuilt 1979 · S/N 31-7912124 N40CZBeast Aero Consulting And Training LLC · Rosamond, CAS/N 0763 N40DACirrus Design Corp · Duluth, MNBuilt 1965 · S/N 30-904 N40DCWright Innovators LLC · Sebastian, FLBuilt 1988 · S/N 561 N40DLStyer David B · Pendleton, ORBuilt 1971 · S/N 071 N40DMChapman Randy J · Jackson, NHS/N 2102 N40DRRoss David R · Wakeman, OHBuilt 1991 · S/N DR-01 N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675 N40EHHibler Phillip E · Alameda, CABuilt 1995 · S/N 2067 N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92 N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569 N40ESP.C. Air LLC · Lockport, NYBuilt 2008 · S/N 71432 N40EWWka Incorporated · Kendallville, INBuilt 1993 · S/N 27-0164 N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114 N40GECuckler Dale E · Tulsa, OKBuilt 1998 · S/N 1545 N40GRPetao LLC · Trinity, FLBuilt 2003 · S/N 21980 N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309 N40HPRock Communications LLC · Rock Hill, SCBuilt 2000 · S/N 4636264 N40HUMoore Charles B · Miles City, MTBuilt 1996 · S/N 1315

Back to AD 87-10-06 R1