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.

N898JRKokosa Vernon R · Dennis, MABuilt 1975 · S/N AA5-0706N898JWWeiswasser Jonathan M · Montclair, NJBuilt 2004 · S/N 81639N898NDKleyn Transportation LLC · Grand Rapids, MIBuilt 2007 · S/N 40054N898PTitus Aviation LLC · Fresno, CAS/N 28-7515403N898RVAcree Joseph R · Calhoun, GABuilt 2012 · S/N 40030N898SCBmsb Aviation LLC · Bogart, GABuilt 2007 · S/N 80533N898SEFrieling Judson D · Houston, TXBuilt 2015 · S/N 41153N898TTMayes Kevin A · Rockwall, TXBuilt 2014 · S/N 83363N8990FDeon Esterhuizen Inc · Clearwater, FLBuilt 1974 · S/N 640313N8990JStites Charles Harold · Chapel Hill, NCBuilt 1966 · S/N 28-3014N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451N8991JCavoto Allyn E III · Adrian, PABuilt 1965 · S/N 28-3015N8991PCendejas Agustin · Chino, CABuilt 1966 · S/N 24-4452N8991YWaldemar Mojica · Arecibo, PRBuilt 1974 · S/N 18-7409133N8992JMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1965 · S/N 28-3016N8992NBenedict Kevin M · Lakeland, FLBuilt 1970 · S/N 32-40875N8992PL And L Aviation Inc · Mount Airy, MDBuilt 1966 · S/N 24-4453N8992RBcm Consulting Inc · Wilmington, DEBuilt 1992 · S/N 20605N8992VFreeze Otis C · Frankston, TXBuilt 1974 · S/N 17264347N8992WKelk Investment Management LLC · Lake Tomahawk, WIBuilt 1965 · S/N 28-10572N8993DKey James M · Hermiston, ORBuilt 1958 · S/N 18-6397N8993JHealy Law Offices Pc · Tyler, TXBuilt 1965 · S/N 28-3017N8993PPitcher Benjamin Alan · Fishers, INBuilt 1966 · S/N 24-4454N8993RMiller Scott A · Piney Flats, TNBuilt 1960 · S/N 7GCB-22N8993VBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 17264348N8993YAirglas Inc · Anchorage, AKBuilt 1974 · S/N 18-7409135N8994JBatham Carin C · Yuba City, CABuilt 1965 · S/N 28-3018N8994RT & H Aviation LLC · Rector, ARS/N 45N8994WLong Evertt W · Wichita, KSFirst renewal noticeBuilt 1964 · S/N 28-10575N8995DGraham William Franklin III · Port Alsworth, AKBuilt 1958 · S/N 18-6403N8995JBloomquist Eric R · Phoenix, AZBuilt 1965 · S/N 28-3019N8995WBlair Maksim J · Pensacola, FLBuilt 1964 · S/N 28-10576N8996EHooligan Air LLC · Ponce Inlet, FLBuilt 1976 · S/N 28-7690217N8996NBickford Shawn A · Auburn, CABuilt 1969 · S/N 32-40879N8996VBaumgartner Scot W · Colby, WIBuilt 1974 · S/N 17264351N8996WVan Seghbroeck Jeffrey A · Zion Crossroads, VABuilt 1965 · S/N 28-10577N8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 18-7409138N8997DFinley Peter T · Bismarck, NDBuilt 1958 · S/N 18-6405N8997JKakuska Michael · Madison, WIBuilt 1965 · S/N 28-3021N8997PF2 Management LLC · Canoga Park, CAS/N 24-4458N8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEBuilt 1974 · S/N 17264352N8997WDockers Elite Aviation LLC · Towanda, KSBuilt 1964 · S/N 28-10579N8998EGeorgetson Michael J · Sayre, PABuilt 1976 · S/N 28-7690219N8998JObrien Robert · Warrens, WIBuilt 1966 · S/N 28-3022N8998NHangar Cc5 LLC · Gainesville, GABuilt 1969 · S/N 32-40881N8998PMoore Jeffrey · Oceanside, CABuilt 1966 · S/N 24-4459N89994Lon Aviation LLC · Aspen, COS/N 18-8510N8999DPadgett Benjamin C · Anchorage, AKBuilt 1958 · S/N 18-6407N8999PBednorski Craig A Trustee · Grass Valley, CABuilt 1966 · S/N 24-4376N8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1960 · S/N 7GCB-35
Back to AD 87-10-06 R1