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.

N9880YMerrick Shane · Redgranite, WIBuilt 1961 · S/N 7GCB-73N98811Kadena Aero Club · Apo Ap, CABuilt 1985 · S/N 17276359N98819Oxford Flying Club Inc · Oxford, CTBuilt 1985 · S/N 17276362N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192N9881PSale Reported · Spartanburg, SCSale reportedBuilt 1975 · S/N 25-7556210N9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeBuilt 1975 · S/N 17265825N9881UChristensen Myra J Storms · Pierre, SDBuilt 1976 · S/N AA5A0281N9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1974 · S/N 17264544N98824Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276363N9882DUsda Aphis Ws Atoc · Cedar City, UTBuilt 1959 · S/N 18-6904N9882UNordbye Newell · Eden Prairie, MNBuilt 1976 · S/N AA5A0282N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783N9883PMinden Soaring Club Inc · Minden, NVBuilt 1975 · S/N 25-7556211N98840Aviator Air Flight School LLC · Grand Prairie, TXBuilt 1998 · S/N 18280358N98843American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276367N9884DMartensen Marten · Anchorage, AKS/N 18-6905N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784N9884KSalt Air Inc · Wilmington, DEBuilt 1977 · S/N 32-7840031N9884PVandegriff Cody E · Eagle River, AKBuilt 1976 · S/N 18-7709007N9884VShockley James F · Loves Park, ILBuilt 1974 · S/N 17264546N9884YRoberts Colton C · Bluebell, UTS/N 7GCB-119N98851Jacques Jerry Joseph · Iliamna, AKS/N 18-7188N98853Registered aircraftBuilt 1998 · S/N 18280316N9885DBarney Jeff S · Fairbanks, AKS/N 18-6907N9885PTriple Cub Aviation LLC · Greenbush, MIBuilt 1976 · S/N 18-7709008N9885QAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265829N9885USchneider Fred M Jr · Fishkill, NYBuilt 1977 · S/N AA5A0285N9885VNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 17264547N9885YCentral Air Parts Inc · Staunton, ILS/N 145N9886CAlm Ronald · Kuna, IDBuilt 1978 · S/N R18200482N9886KSmart03 LLC · Kissimmee, FLBuilt 1977 · S/N 28-7816205N9886NHall Benton G · Plano, TXBuilt 1994 · S/N 2230N9886VBognar John W III · Sardinia, NYBuilt 1974 · S/N 17264548N9886WLathem Emma K · Amarillo, TXS/N 28-23406N98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 17276369N9887CLeonard Paul A Jr · Grand Beach, MIBuilt 1978 · S/N R18200484N9887DRegistered aircraftBuilt 1959 · S/N 18-6911N9887LSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276645N9887QTupelo Aeronautics Inc · Tupelo, MSS/N 17265831N9887VDarby Holly M · Midland, TXBuilt 1974 · S/N 17264549N98887Jodkin Jason · Confluence, PABuilt 1985 · S/N 17276373N9888CLoehde Thomas · Lolo, MTBuilt 1978 · S/N R18200485N9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationBuilt 1971 · S/N 17259788N9888WSchlafer Antone · Lincoln, CABuilt 1967 · S/N 28-23408N98893Pape Jason C · Sykesville, MDBuilt 1985 · S/N 17276374N98896Two Tails LLC · Las Vegas, NVBuilt 1998 · S/N 18280350N9889DBorth Johnny D · Meade, KSBuilt 1959 · S/N 18-6914N9889GWright Flight Inc · Tucson, AZBuilt 1971 · S/N 17259789N9889QTack-Morse Patricia M · Sweet Home, ORBuilt 1975 · S/N 17265833
Back to AD 87-10-06 R1