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.

N6922JSystematic Management And Flight Training LLC · Kankakee, ILBuilt 1976 · S/N 28-7690431N6922NPetrie Chris · Titusville, FLBuilt 1968 · S/N 680143N6922UStrategic Aviation Assets LLC · Havre, MTBuilt 1964 · S/N 292N6922WRobirds Ryan E · Wheelersburg, OHS/N 28-21095N6923BWitzel John F Jr · Frenchglen, ORBuilt 1956 · S/N 22-4199N6923DCline Patrick G · Granbury, TXBuilt 1957 · S/N 22-4851N6923NTurner William H · Parkersburg, WVBuilt 1968 · S/N 680181N6923PLopez Ruben Arellano · Nogales, AZS/N 24-2057N6923QWelch William Trustee · Washington, UTBuilt 1967 · S/N MA-279N6924HJeea Aviation LLC · Tyler, TXBuilt 1975 · S/N 17265647N6924PLauderback Lee L · Fort Collins, COBuilt 1960 · S/N 24-2058N6924QPag Air LLC · Concord Township, OHBuilt 1967 · S/N MA-283N6924USchleisman Terry J · St George, UTBuilt 1964 · S/N 294N6924VBramer Aviation LLC · Middleburg, PABuilt 1975 · S/N 22-1304N6924WAlpha 3 LLC · Troy, KSBuilt 1965 · S/N 28-21098N6925NFollrath Rick C · Ludington, MIBuilt 1968 · S/N 680144N6925UDurocher Michael G · New Hudson, MIS/N 295N6925VMay Michael S · Axtell, NES/N 22-1305N6926DGibson Christopher R · Natchez, MSBuilt 1957 · S/N 22-4854N6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeBuilt 1975 · S/N 17265648N6926NTurtle Mountain Air LLC · Bottineau, NDBuilt 1968 · S/N 680183N6926PSkyways Group LLC · Greensboro, NCS/N 24-2060N6926UCreed Stephen R · Fort Worth, TXBuilt 1964 · S/N 296N6926WCola Air LLC · Irmo, SCBuilt 1965 · S/N 28-21101N6927JClear2fly Aerospace LLC · Daytona Beach, FLBuilt 1976 · S/N 28-7625257N6927NFlying High LLC · Gore, VABuilt 1968 · S/N 680145N6927QIowa Military Aviation Heritage Museum · Ankeny, IABuilt 1967 · S/N MA-286N6927UJones Robert Y · Alba, TXS/N 297N6928DRegistration Pending · West Yellowstone, MTRegistration pendingBuilt 1957 · S/N 22-4856N6928HMaya Air Services LLC · Lee, NHBuilt 1983 · S/N ME-405N6928NToysformud LLC · Missoula, MTBuilt 1968 · S/N 680184N6928POwen Colin Jc · College Station, TXBuilt 1960 · S/N 24-2062N6928VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 20-1181N6928WHammons Daniel G · Vadnais Heights, MNBuilt 1965 · S/N 28-21289N6929DJohnson Timothy D · Chapel Hill, NCBuilt 1957 · S/N 22-4857N6929UEisenhardt Scott · Milwaukee, WIBuilt 1964 · S/N 299N6929VHerzog Property Management LLC · Fergus Falls, MNBuilt 1975 · S/N 20-1182N692ACMarshall Carol A · Lees Summit, MOBuilt 2012 · S/N 24350N692ASJgm Aviation LLC · Spring, TXBuilt 2001 · S/N 260006N692CFG&M Aircraft Inc · Wheat Ridge, COS/N 44-7995024N692DWBroyles Danny Keith · New Castle, INBuilt 2005 · S/N 3257384N692HMReagan Jason E · Sevierville, TNBuilt 1997 · S/N 22892N692LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881217N692MADevine James W · Columbus, OHS/N 17700652N692SEmley Steven Allen · Port Angeles, WABuilt 1992 · S/N 28N692SPSmith Holdings Inc · Wilmington, DEBuilt 1999 · S/N 172S8102N692TBJenkins Clifford C · Shidler, OKS/N 1692N6930JSkypark Aero Club Inc · Troy, OHBuilt 1976 · S/N 28-7690432N6930VMatisko Michael J · Newburgh, INBuilt 1975 · S/N 20-1183N6930WFlat Out Aviation LLC · Mercer, MOS/N 28-21105
Back to AD 87-10-06 R1