OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N207AMHilger Michael D · Inver Grove, MNBuilt 2000 · S/N 23157N207CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881001N207CWWalls Craig C · Willow, AKS/N 001N207DKKufalk Darrell · Dousman, WIBuilt 2007 · S/N 3RX109N207DMThomson Mary Ellen · East Berlin, PABuilt 1985 · S/N 207N207ESPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020254N207GAGreer Robert H · Hudson, NHBuilt 1992 · S/N 3207N207HPCampbell James W · Geneva, ALBuilt 1982 · S/N 17275543N207JTTozer John E · Orono, MEBuilt 1979 · S/N 6006317961200N207LHSnaproll Inc · Wilmington, DEBuilt 1997 · S/N 052N207LSNightbreak Aviation LLC · Houston, TXBuilt 1968 · S/N 680072N207LTFreitag William W Jr · Lakeway, TXBuilt 2011 · S/N 91680N207MAStreamline Aviation LLC · Battlefield, MOS/N 32-40923N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092N207PDFirefly Leasing Inc · South Carver, MABuilt 2003 · S/N 1330N207RDSpry Brent A · Madison, INBuilt 1977 · S/N AA5A0449N207SADyer LLC · Dyer, TNBuilt 1998 · S/N 18280140N207TJBoos Timothy J · Fort Atkinson, WIBuilt 2007 · S/N 71909N207VRB&C Properties LLC · Bristol, WIS/N 32-58N207XBane Russell · Palm Beach Gardens, FLBuilt 2005 · S/N 1207N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841N20807Dyess William C · Franklin, TNFirst renewal noticeBuilt 2005 · S/N 25772N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147N2080QHyperion Enterprises LLC · Warrenton, VABuilt 2005 · S/N T18208450N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843N20816Dawson Matthew · Springfield, MOBuilt 1980 · S/N 32R-8029001N20817Beard Russell G · Goodyear, AZBuilt 1978 · S/N 32R-7887179N2081AKing David M · Ormond Beach, FLBuilt 1978 · S/N 32R-7885283N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128N2081TBaker Holdings LLC · Bedford, PAS/N 28R-7135025N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849N20826Lc Aviation LLC · Mocksville, NCBuilt 2004 · S/N 0182N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853N20848Lown Jeffrey B II · Shrewsbury, NJBuilt 1979 · S/N 28-7911080N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081N2084DWaves4days LLC · El Segundo, CABuilt 2004 · S/N SRG061N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857N2085POphelia Aviation LLC · Paradise Valley, AZBuilt 1979 · S/N 28-7911102N2085TBlue Skies Aircraft LLC · Kalispell, MTS/N 28R-7135029N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026
Back to AD 87-10-06 R1