OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N7820NPisas Flyers Inc · East Alton, ILBuilt 1968 · S/N 28-5272N7820WJamah Hani · Boonville, CAS/N 28-1829N7821CArmy Knife Enterprises LLC · Oak Hills, CABuilt 1975 · S/N 28-7690084N7821NStradtner Adam · Laporte, INBuilt 1968 · S/N 28-5273N7823NKaiten Aviation LLC · North Haven, CTBuilt 1968 · S/N 28-5275N7823WCdm Dirt LLC · Snowflake, AZBuilt 1964 · S/N 28-1840N7824CRegistered aircraftBuilt 1975 · S/N 28R-7635118N7824NMcatarian Mark F · Saint Marys, KSBuilt 1969 · S/N 28-5277N7824TRoss Charles · Midlothian, TXBuilt 1978 · S/N 32R-7887032N7824WHornbill Aviation LLC · Incline Village, NVBuilt 1964 · S/N 28-1835N7825ND&D Vision Air LLC · Aubrey, TXBuilt 1968 · S/N 28-5278N7825WNelson Aaron D · Carver, MNBuilt 1964 · S/N 28-1837N7827NBest John P · Goldsboro, NCBuilt 1969 · S/N 28-5280N7827WWoods Perry H · Brownsville, TXS/N 28-1842N7828NBurris Jamey E · Mt Juliet, TNBuilt 1969 · S/N 28-5281N7828WIliff Aircraft Repair And Service Co Inc · Tulsa, OKBuilt 1966 · S/N 28-3759N7829NRoth Colin E · Anchorage, AKBuilt 1969 · S/N 28-5282N7829WBormann Charles F · Mooresville, NCBuilt 1964 · S/N 28-1844N782CAChristman Matthew T · Markle, INBuilt 1966 · S/N 28-21849N782GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881464N782LAN782la LLC · Philadelphia, PABuilt 2025 · S/N 28020214N782MFWallace State Community College · Hanceville, ALBuilt 2023 · S/N 28020122N7830NGonzalez Braulio A · Bourbonnais, ILBuilt 1969 · S/N 28-5284N7830WWildhaber Andrew W · Coal Creek, COBuilt 1964 · S/N 28-1845N7831NRadar Service Terminated LLC · New York, NYBuilt 1969 · S/N 28-5285N7832WRankin Kevin J · Maryville, MOBuilt 1964 · S/N 28-1849N7833NStrait Brian C · Joplin, MOBuilt 1969 · S/N 28-5287N7833WLukehart Steve D · Lincoln, NEBuilt 1964 · S/N 28-1850N7834NVector Aviation LLC · Mentor, OHBuilt 1969 · S/N 28-5288N7834WCleek Norris E · Orland, CABuilt 1964 · S/N 28-1851N7835NOrrill Bill · Godfrey, ILBuilt 1969 · S/N 28-5289N7836NMelancon Scottie J · Baton Rouge, LABuilt 1969 · S/N 28-5291N7837WHock Matthew G · Culbertson, NEBuilt 1964 · S/N 28-1854N7838NWright David P Jr · Chandler, AZBuilt 1969 · S/N 28-5293N7839NHaddle Eddie J · Lindon, UTBuilt 1969 · S/N 28-5295N783LAN783la LLC · Philadelphia, PABuilt 2025 · S/N 28020215N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228N7840NBiby Steven R · Churchs Ferry, NDBuilt 1969 · S/N 28-5294N7840WTomic Milos · Westminster, COBuilt 1964 · S/N 28-1857N7841WBasin Flyers LLC · Klamath Falls, ORS/N 28-1858N7842FIso Art Ltd · Hamilton, MTS/N 28R-7703004N7842NBoon Andrea Elizabeth · Bloomingdale, NYBuilt 1969 · S/N 28-5297N7843NA10 Aviation LLC · Peachtree City, GABuilt 1969 · S/N 28-5298N7844WSaddy Rock · Henderson, NVS/N 28-1861N7846NWelch Koby Adam · Bel Air, MDBuilt 1969 · S/N 28-5302N7846WJohnpeer Kate M · Whittier, CABuilt 1964 · S/N 28-1864N7847WErickson Richard M · Summerville, SCBuilt 1964 · S/N 28-1865N7848CZeitler Christopher · Middleton, WIBuilt 1975 · S/N 28-7690085N7848NRunions David W · Elon, NCBuilt 1969 · S/N 28-5304N7848WStockman Richard Benjamin · Southaven, MSS/N 28-1866
Back to AD 87-08-08 R3