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.

N6084NHilpertshauser David J · Sheboygan, WIBuilt 1969 · S/N M-1184 N6084QHammond Edward M · Grass Valley, CABuilt 1965 · S/N 3257 N6084RKdb Flying LLC · Branchville, SCBuilt 1965 · S/N 17253753 N6085FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020153 N6085LLevy Stanley · Arcadia, CABuilt 1972 · S/N AA5-0185 N6085NShuffield Brian D · Oregon House, CAS/N M-1177 N6085SSkyline Soaring Club Inc · Front Royal, VABuilt 1993 · S/N 1236 N6085XLight Richard S · Wichita, KSBuilt 1960 · S/N 1681 N6085YPharmair LLC · Jackson, MSBuilt 1966 · S/N 27-3287 N6086GAbovestandard LLC · Denison, TXBuilt 1979 · S/N 17273566 N6086SDos Lobos Aviation LLC · Yankton, SDBuilt 1980 · S/N R18201610 N6086UStearman Air Tours Inc · Gatesville, NCBuilt 1994 · S/N 1262 N6086WPegasus Ir LLC · Miami, FLBuilt 1964 · S/N 28-20100 N6087EGuletsky Stephen W · Goshen, CTBuilt 1994 · S/N 5312 N6087LSundsmo Sheldon L · Adams, WIBuilt 1972 · S/N AA5-0187 N6087PBrandner Paul D · Lake Tapps, WABuilt 1959 · S/N 24-1186 N6087QTyson Michael A · Cupertino, CABuilt 1965 · S/N 910 N6087UN6087u LLC · Homestead, FLBuilt 1994 · S/N 1285 N6088DSale Reported · Langley, WASale reportedBuilt 1956 · S/N 22-4742 N6088LCollins Harold H · North Las Vegas, NVBuilt 1972 · S/N AA5-0188 N6088QParker Justan · New Durham, NHBuilt 1965 · S/N 911 N6088UPotter Timothy E · Murfreesboro, TNBuilt 1993 · S/N 1248 N60895Donald Williamson · Piedmont, SDBuilt 1969 · S/N 15070652 N6089DHoyt William C · Trimble, MOBuilt 1956 · S/N 22-4743 N6089FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020154 N6089KDelta State University · Cleveland, MSBuilt 1980 · S/N 17274166 N6089PMichaelsen Richard P · Sanborn, NYBuilt 1959 · S/N 24-1188 N6089QMolnar Victor · Ballston Spa, NYBuilt 1965 · S/N 3259 N6089UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1994 · S/N 5311 N6089YAerosavant LLC · Towanda, PABuilt 1966 · S/N 27-3295 N608ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843758 N608DSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2002 · S/N 40.217 N608FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020208 N608FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916328 N608GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881194 N608LESimons Barry · Inverness, FLS/N 28-7911298 N608MABair Jay D · Ephrata, WABuilt 2012 · S/N 91562 N608PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841217 N608SCovey John R · Amboy, MNS/N 1030 N608TMMarijono Vendy · Charlotte, NCBuilt 1981 · S/N 32-8206004 N6090BPlane Fun Inc Tr Trustee · Snellville, GABuilt 2000 · S/N 857 N6090DWoolard Wayne W · Bath, NCBuilt 1956 · S/N 18-5450 N6090FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020155 N6090LDarcor Inc · Hampstead, NCBuilt 1972 · S/N AA5-0190 N6090PBasin Franchising LLC · Vernal, UTBuilt 1959 · S/N 24-1189 N6090VRoberts Jon J · Parker, COBuilt 1980 · S/N 172RG0573 N6090XAstle James H · Saint John, KSBuilt 1960 · S/N 1688 N6091DMentone Flying Club · Rochester, INBuilt 1979 · S/N 17272599 N6091FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020156 N6091LMartino John F · Kingston, NYBuilt 1972 · S/N AA5-0191

Back to AD 87-10-06 R1