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.

N943KSStark James E Trustee · Sun City, AZBuilt 1978 · S/N 17270273N943MAMiller Joseph T IV · Bethel, NCBuilt 2009 · S/N 40663N943NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881922N943RVShea Tim M · Pearland, TXBuilt 1993 · S/N JB 2644N943SPLittle Airplanes LLC · Aurora, ORBuilt 1999 · S/N 172S8138N943TEZbikowski Scott · Lino Lakes, MNBuilt 2003 · S/N 10222N943TTCkz Ventures LLC · Anchorage, AKBuilt 2005 · S/N 10748N943ZAHowie Express LLC · Highland, MIBuilt 2005 · S/N T18208408N9440JDeascentis Dean · Lincoln, CAS/N 28-3552N9440NEshowe Aviation Inc · East Peoria, ILBuilt 1969 · S/N 28R-35154N9440VVanhorn Jonathan F · Laguna Hills, CABuilt 1970 · S/N 700030N9440WLicausi Dan · Cathedral City, CABuilt 1968 · S/N 28-11155N9441VKarge Robert F · Peachtree City, GAS/N 700034N9441WBaker Carl · Angleton, TXBuilt 1968 · S/N 28-11157N9441ZTjb Capital LLC · Nashville, TNBuilt 1998 · S/N 18280214N9442CElevate Aviation LLC · Rathdrum, IDBuilt 1978 · S/N 32-7840098N9442FRhodes Terry G · Snohomish, WABuilt 1966 · S/N 115-0213N9442NClear2aviate LLC · Ionia, MIBuilt 1969 · S/N 28R-35156N9442P42papa LLC · Soldotna, AKBuilt 1974 · S/N 18-7409129N9442RPauly Jeff D · Watkins, MNBuilt 1978 · S/N R18200706N9442VFlight Operations Academy LLC · Prescott, AZS/N 700049N94435Gibler Robert R · Peachtree City, GABuilt 1972 · S/N 287225072N9443HAllport Bruce E · North Hollywood, CABuilt 1975 · S/N 17266156N9443NSchulz John B Jr · Marquette, MIBuilt 1969 · S/N 28R-35157N9443PNyhus Daniel Alan · Payson, AZBuilt 1970 · S/N 24-4951N9443WC H Draw Co Inc · Park City, KSBuilt 1968 · S/N 28-11161N9444DHurlbert Michael · Wasilla, AKBuilt 1958 · S/N 18-6687N9444HPrestige Worldwide Aerospace LLC · Panama City, FLBuilt 1975 · S/N 17266157N9444WMacedo Carlos C · Dayton, OHBuilt 1969 · S/N 28-11163N9445DTriple Fes LLC · San Antonio, TXBuilt 1984 · S/N 172RG1165N9445HBrown Max K · Cushing, OKBuilt 1975 · S/N 17266158N9445JRamey Austin B · Salida, CABuilt 1966 · S/N 28-3557N9445KAishvaryam LLC DBA · Lancaster, TXBuilt 1976 · S/N 28-7615203N9445WEnglund Gary · Goldendale, WABuilt 1969 · S/N 28-11164N9446JFitch Stephen C · Moreno Valley, CABuilt 1966 · S/N 28-3558N9447HLang Julia A · Greensburg, PABuilt 1975 · S/N 17266159N9447LAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1986 · S/N 17276559N9447NEvans Jeff W · Hannibal, MOBuilt 1969 · S/N 28R-35162N9447WZiemann Mark · Camp Verde, AZBuilt 1969 · S/N 28-11166N9448DLinear Farming Inc · Pleasant Grove, CABuilt 1958 · S/N 18-6691N9448JRichmond Heights LLC · Pocahontas, ARBuilt 1966 · S/N 28-3560N9448NMason Harold R · Quincy, WABuilt 1969 · S/N 28R-35163N9448PMgh Inc · Aurora, NEBuilt 1974 · S/N 18-7409130N9448WKlein Richard J · Greenville, MIBuilt 1969 · S/N 28-11167N9449DHall Aircraft LLC · Kenai, AKBuilt 1958 · S/N 18-6692N9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeBuilt 1969 · S/N 28R-35164N9449VClark Jeff W · Piedmont, MOBuilt 1970 · S/N 700051N9449WProfessional Pilots Inc · Lowell, INBuilt 1968 · S/N 28-11168N944AFStanaski Andrew J · Cary, NCBuilt 2015 · S/N 81675N944AKSulphur Creek Helicopters LLC · George West, TXBuilt 2005 · S/N 10634
Back to AD 87-10-06 R1