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.

N782FMFmfa Inc · Wilmington, DEBuilt 1981 · S/N 17274667N782GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881464N782LAN782la LLC · Philadelphia, PABuilt 2025 · S/N 28020214N782LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 4496372N782MFWallace State Community College · Hanceville, ALBuilt 2023 · S/N 28020122N782NDFox Leasing Group LLC · Hollywood, FLBuilt 2016 · S/N 4496397N782POrear Jeffrey W · Peshtigo, WIBuilt 2006 · S/N 25171N782RGL-Bird LLC · Hood River, ORBuilt 1978 · S/N R18200194N782RMMbs Aviation LLC · York, SCBuilt 2005 · S/N 18281730N782SHJtc Aviation LLC · Nashville, TNBuilt 2004 · S/N 3616N782SNKingdom Air Corps · Sutton, AKBuilt 1973 · S/N 17261341N782WPPhelps Kevin D · Hobe Sound, FLBuilt 2011 · S/N 71355N782WWDraco Flight School DBA · Chino, CABuilt 1997 · S/N 17280295N782YBeitler Richard J · Pittsburgh, PABuilt 1978 · S/N M-2004N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530N7830NGonzalez Braulio A · Bourbonnais, ILBuilt 1969 · S/N 28-5284N7830WWildhaber Andrew W · Coal Creek, COBuilt 1964 · S/N 28-1845N7830YGospel Ministries International Inc · Mc Donald, TNBuilt 1965 · S/N 30-906N78312Roemer Joanne · Kemah, TXS/N 17257565N7831NRadar Service Terminated LLC · New York, NYBuilt 1969 · S/N 28-5285N78329Tindall William M · Pensacola, FLS/N 27-2329N7832DCamp Barry G · Lafayette, LAS/N 22-5478N7832PInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 24-3052N7832VBaker Benjamin D · Catasauqua, PAS/N 2935N7832WRankin Kevin J · Maryville, MOBuilt 1964 · S/N 28-1849N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567N78331Clifton Jack D · La Junta, COS/N 17257568N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573N7833BAnderson Bryan C · Arlington, TNBuilt 1959 · S/N 24-952N7833GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259533N7833NStrait Brian C · Joplin, MOBuilt 1969 · S/N 28-5287N7833PPeters Jakob G · Tempe, AZS/N 24-3053N7833WLukehart Steve D · Lincoln, NEBuilt 1964 · S/N 28-1850N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578N7834GSmith Perry L · Brook Park, MNS/N 17259534N7834NVector Aviation LLC · Mentor, OHBuilt 1969 · S/N 28-5288N7834PRegistered aircraftBuilt 1962 · S/N 24-3054N7834VMorris Tommy R · Houston, TXBuilt 1964 · S/N 2870N7834WCleek Norris E · Orland, CABuilt 1964 · S/N 28-1851N7834YBall Half Out LLC · Mesa, AZBuilt 1965 · S/N 30-911N78351Caron John · Ellsworth, MIBuilt 1968 · S/N 17257579N78354Tonar Richard J Jr · Omaha, NES/N 17257581N78355Fleming Gary R · Wickliffe, KYBuilt 1968 · S/N 17257582
Back to AD 87-10-06 R1