OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N6211WMchone Robert S · Rockingham, VABuilt 1964 · S/N 28-20246N6212WSoto Miguel · Windcrest, TXBuilt 1964 · S/N 28-20247N6213WDunn William R · Indio, CABuilt 1964 · S/N 28-20249N62147Stevens James A Jr · Morganton, NCBuilt 1979 · S/N 287990289N6214JSale Reported · Mikado, MISale reportedS/N 28-7625231N6216JThibeault Barbara C Horne · Eagan, MNBuilt 1976 · S/N 28-7615335N6217CButler Donald D · Petersburg, PABuilt 1973 · S/N 28-7310114N6217HWalker Robert J · Manvel, TXBuilt 1977 · S/N 28-7816237N6217JNathaniel Greene Dev Corp · Stanardsville, VAFirst renewal noticeBuilt 1976 · S/N 28-7690373N6218JNelson Jeffery M · Eagle River, AKBuilt 1976 · S/N 28-7690374N621ACFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2014 · S/N 2843759N621BFBoldflight LLC · Danville, INBuilt 1973 · S/N 28-7425123N621DBSouth Houston Aviators LLC · Pearland, TXBuilt 1978 · S/N 32R-7985016N621FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020026N621FLKiani Behdad · Elk Grove, CABuilt 1971 · S/N 28-7125508N621FTFlorida Institute Of Technology · Melbourne, FLBuilt 1984 · S/N 28-8416124N621HSBlue Skies Flying Services Inc · Lake In The Hills, ILBuilt 1973 · S/N 28-7415082N621KHMoody Aviation Management LLC · Forest, VABuilt 1979 · S/N 32R-7985086N621LPM2 Equipment LLC · Lubbock, TXBuilt 2004 · S/N 3232026N621NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881159N621RMLouie Garrick S · Reno, NVBuilt 1997 · S/N 3257019N621TGSchmotzer Donald S · Ladson, SCS/N 32-7940056N621TKSheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881519N6220WPuls Timothy W · Plainfield, ILBuilt 1964 · S/N 28-20259N6221JReese Joel Scott · New Smyrna Beach, FLBuilt 1976 · S/N 32R-7680334N6221XAlpha 3 LLC · Newcastle, OKS/N 28-24307N6222HMortenson Lyle · Kennebec, SDBuilt 1977 · S/N 28R-7837058N6222JSafaero Inc · San Clemente, CABuilt 1976 · S/N 32R-7680335N6222SClear Sky Aviation LLC · Lewis Center, OHBuilt 1973 · S/N 28R-7335197N6223JVanderstoel Alex T · Waterford, CABuilt 1976 · S/N 28-7625232N6224JRrr Transportation LLC · Oneonta, ALBuilt 1976 · S/N 28-7615337N6225JWolf Ronald · Abbeville, LABuilt 1976 · S/N 28-7615338N6226JXigent Aviation Inc · Wilmington, DEBuilt 1976 · S/N 28-7690375N6226WN6226w Inc · Solon, IABuilt 1964 · S/N 28-20267N6228JRegistration Pending · Fort Myers, FLRegistration pendingBuilt 1976 · S/N 32-7600018N6228WKoshan Kathryn E · Edgewater, FLBuilt 1964 · S/N 28-20270N6229JVidosh Brian Jr · Friendswood, TXBuilt 1976 · S/N 32R-7680336N6229WSpray Terry Lee · Utica, ILS/N 28-20255N622CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881514N622FLMontgomery Lauryn A · Minor Hill, TNBuilt 1971 · S/N 28-7125509N622NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881160N6230JSonnichsen Landen D · Delta Junction, AKBuilt 1976 · S/N 32R-7680337N6231HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816238N6231WMission Air LLC · Oklahoma City, OKBuilt 1964 · S/N 28-20271N6232HParis Air Inc · Vero Beach, FLS/N 28-7816240N6232WN6232w LLC · Rushland, PABuilt 1964 · S/N 28-20272N6234CSchilling Aviation Services LLC · Salina, KSBuilt 1978 · S/N 28-7890349N6234JLane Jerry P · Grinnell, IABuilt 1976 · S/N 28-7615339N6234WDahlenburg Tory L · Smyrna, TNBuilt 1964 · S/N 28-20275N6235HAirworthyone LLC · Caledonia, MIBuilt 1977 · S/N 28-7890219
Back to AD 87-08-08 R3