AD 87-10-06 R1

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

N9307MCassling Edward F · Newark Valley, NYBuilt 1966 · S/N 1240N9307SRearick Scott P · Frederick, MDBuilt 1975 · S/N MC-337N9307WHedgers Thomas W · Lino Lakes, MNBuilt 1967 · S/N 28-10986N9308JYoung Ashley G · Lexington, NCBuilt 1966 · S/N 28-3400N9308MDegraaf Derrick B · Manteca, CABuilt 1966 · S/N 1241N9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCBuilt 1969 · S/N 24-4804N9308VDapaah Seth O · Upper Marlboro, MDBuilt 1969 · S/N 690086N9308WHubbard Manu L · Riverside, CABuilt 1967 · S/N 28-10987N9309KVera Rojas Guillermo A · Albuquerque, NMBuilt 1976 · S/N 28-7615194N930AMDel Mar College · Corpus Christi, TXBuilt 1984 · S/N 0351N930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 4496154N930GFThierry Robert J · Pottstown, PABuilt 1987 · S/N 930N930KGGriggs Roger · Columbia, SCS/N 32R-8029027N930LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496418N930MCook Christopher K · Wintersville, OHBuilt 2015 · S/N 40741N930MAPlaceway Scott M · Lapeer, MIBuilt 2020 · S/N 2881404N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787N930TEPeters James L · Lindon, UTBuilt 2002 · S/N 10209N930ZMirage 930 Corp Trustee · Wilmington, DEBuilt 1995 · S/N 4622188N931Registered aircraftBuilt 1993 · S/N 5297N9310DRegistered aircraftBuilt 1982 · S/N 172RG1116N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080N9310JBuckwalter Russell · Broadway, VABuilt 1966 · S/N 28-3403N9310NApproach Partners LLC · Franklinton, NCBuilt 1969 · S/N 28R-35010N9310WGb Aviation LLC · Alpine, CABuilt 1967 · S/N 28-10990N9311DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1958 · S/N 22-6322N9311JSentelle Amanda L · Frederick, MDBuilt 1966 · S/N 28-3404N9311MShamshir LLC · Lake Havasu City, AZBuilt 1966 · S/N 1244N9311NAmendt Joseph J III · Plymouth, MNBuilt 1969 · S/N 28R-35011N9311VRegistration Pending · Queen Creek, AZRegistration pendingBuilt 1969 · S/N 690090N9312DMcdonald Steve W · Lino Lakes, MNBuilt 1958 · S/N 22-6323N9312MSteinman Marc J · Frankfort, ILBuilt 1966 · S/N 1245N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081N9313JLockhart Michael B · Redlands, CABuilt 1966 · S/N 28-3406N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241N9313M9313 Mike Inc · New Smyrna Beach, FLBuilt 1966 · S/N 1246N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809N9313WDjb Aviation LLC · Pompano Beach, FLBuilt 1967 · S/N 28-10993N9314DCallahan Ashton G · Homer, AKBuilt 1958 · S/N 22-6325N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220N9314HAzevedo Bradley J · San Francisco, CABuilt 1981 · S/N 18267931N9314PCapoferri Robert · Hammonton, NJBuilt 1998 · S/N 9314N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118N9315ESmith Mark S · Cornville, AZS/N 17272221N9315JKruthoff Bret · Charles City, IABuilt 1966 · S/N 28-3425N9315NDiir County Flying Inc · Sturgeon Bay, WIS/N 28R-35015
Back to AD 87-10-06 R1