OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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
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.

N28896Pafford David A · Floydada, TXS/N AA5B0752N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289N2889ZPeters Thomas K · Wasilla, AKBuilt 1959 · S/N 18-7066N288ABSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1962 · S/N 24-3033N288AWRegistered aircraftBuilt 2004 · S/N 81684N288BCInnovations Educational Consulting Inc · Eden, UTBuilt 2012 · S/N 30045CN288BDHop Props LLC · Houston, TXBuilt 2003 · S/N 80595N288BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881751N288BTValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 18281607N288CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881635N288CDKrempp Michael E · Arlington, TXBuilt 2006 · S/N 18088CN288CFAdams Charles R · Granbury, TXBuilt 1978 · S/N AA5B0840N288FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-23767N288GHBowen Christina M · Shreveport, LAS/N 28-1938N288HCLampe Erik J · Appleton, WIBuilt 1992 · S/N 10101N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482N288KDavison Pere · Cody, WYBuilt 2003 · S/N 80240N288MCTomanec Jean · Victoria, TXBuilt 2002 · S/N 18281110N288MDDietl Manfred · Naples, FLBuilt 2001 · S/N 2177N288MESouth Dakota State University · Brookings, SDBuilt 2000 · S/N 172S8548N288PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 2843502N288RSale Reported · Northfield, MASale reportedS/N 288RN288RTSavonen Stephen D · Ukiah, CABuilt 1967 · S/N 7KCAB-43N288RVBarrientos Jeri D · Collinsville, OKS/N 83535N288STRegistered aircraftBuilt 2005 · S/N 3763N288WEAviators LLC · Edina, MNBuilt 1983 · S/N 32-8324008N288WPPhillips William D · Forsyth, GAFirst renewal noticeBuilt 2011 · S/N 81808N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890N28917Turnage Andrew · Houston, TXBuilt 1978 · S/N AA5B0888N2891PHula Jesse M · Anchorage, AKBuilt 1956 · S/N 18-4489N2891TVagias Janet Rose · Niceville, FLBuilt 1972 · S/N 28-7225270N2891ZSale Reported · Lantana, TXSale reportedBuilt 1978 · S/N 375-78N28923Brown Robert · Rye, NHBuilt 1978 · S/N AA5B0890N28926Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881233N28927Platt Jeremie Aaron · Rich Hill, MOBuilt 1978 · S/N AA5B0894N28929Ramsay Farms And Elevator · Rockville, INS/N AA5B0895N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363N2892TScherman Dale M · Ottertail, MNBuilt 1972 · S/N 28-7225272N2892ZDykema Richard H · Soldotna, AKBuilt 1959 · S/N 18-7075N28930Mayer Steven T · Aurora, ORBuilt 1978 · S/N AA5B0896N28933Lewis Group Properties LLC · Apex, NCBuilt 1979 · S/N 32-7940123N28934Johnson Grant M · Odessa, FLBuilt 1981 · S/N 32R-8129008N28935Kremer Brian F · Iona, MNBuilt 1979 · S/N 32-7940124N2893EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271364N2893MRls Rental Co Inc DBA · Joplin, MOBuilt 1977 · S/N 28-7816321N2893POaero LLC · Boise, IDBuilt 1955 · S/N 18-4491N2893XOlson Philip D · Garden Plain, KSBuilt 1967 · S/N 17700293
Back to AD 87-10-06 R1