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.

N4568RChuss Edward J · Metamora, MIBuilt 1965 · S/N 28-21326 N4569CReese Brandon A · Bend, ORS/N 25423 N4569HPowell Randy N Trustee · Elko, NVBuilt 1979 · S/N 24-0849 N4569RNoco Flying Club LLC · Fort Collins, COBuilt 1966 · S/N 28-21310 N4569XSequoias David O · Waxhaw, NCBuilt 1975 · S/N 287625057 N4569YDebilt Bruce A · Berthold, NDBuilt 1967 · S/N 25-4232 N456AMKrause Kade G · Jackson, MTBuilt 1998 · S/N 1412 N456ASGutman Daniel W · North Andover, MABuilt 2004 · S/N 40.456 N456BHCastleton Real Estate & Developlment Inc · El Monte, CAS/N R18201482 N456BTHatfield Timothy E · Parowan, UTBuilt 2013 · S/N 4712 N456CASlake James T · Portage, INBuilt 1966 · S/N 28-10733 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506 N456DSlesser Carl J · Crestwood, KYBuilt 1993 · S/N 21569 N456DALiberty Air LLC · Christiansted, VIBuilt 1979 · S/N 31-7912103 N456DJSingle Raj Pa Inc · Seattle, WABuilt 1982 · S/N R18201888 N456DPBorder Zachary J · Molalla, ORBuilt 1991 · S/N 365 N456DWJstream Lc · Sheridan, WYS/N 21040 N456EASpasco LLC · Helena, MTBuilt 1989 · S/N 4622042 N456EMMiller William E · Goldsboro, NCBuilt 2013 · S/N 91893 N456HLCrawford Clark W Trustee · La Quinta, CABuilt 2013 · S/N 72282 N456HUCornelius Wayne · Mount Arlington, NJBuilt 1998 · S/N 1436 N456JDLehner Jeffrey K Trustee · The Woodlands, TXBuilt 2004 · S/N 80485 N456LLemma Joseph M · Parker, COBuilt 1962 · S/N 28-863 N456LWPhillips Operating Lp · Shreveport, LABuilt 1987 · S/N 63 N456MDMyres Mark D · Freeland, WABuilt 1996 · S/N 20107 N456PBooth Donald V · Denison, TXS/N 24-3276 N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97 N456PCMendelson Mark L · Owego, NYBuilt 2018 · S/N 25787 N456PMBerry Michael G · Hot Springs, ARBuilt 1966 · S/N 28-22354 N456RBSammons Michael A · Lubbock, TXS/N 654 N456RHMalik Todd S · Matthews, NCBuilt 1979 · S/N AA5B1252 N456RJGraae Michael Horace · Los Angeles, CABuilt 1995 · S/N 21701 N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457 N456SGGavitt Stephen M · Rensselaer, NYBuilt 2010 · S/N 91307 N456SPAc Aviation LLC · Ocklawaha, FLBuilt 1999 · S/N 172S8320 N456TBValentine David L · Katy, TXBuilt 1999 · S/N 1911 N456TGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 11136 N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319 N456TWSchmidt Gail M · Florence, COBuilt 2007 · S/N 02-1217 N456WMWright Alfred M · Toney, ALBuilt 2001 · S/N 001 N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353 N4570MMatthews Richard W · Kasilof, AKBuilt 2018 · S/N 040750 N4570TWinslow Dean L · Stanford, CABuilt 1972 · S/N 28-7210013 N4570WGuffey Jerry D · Lebanon, TNS/N 13060 N4571TVandeventer Matthew S · Dillingham, AKS/N 32-7200023 N4571WBernard Scott Sr · Denham Springs, LAS/N 13061 N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039 N4571YDavis James J · Beaver Dam, WIBuilt 1967 · S/N 25-4235 N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062

Back to AD 87-10-06 R1