OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N595WLeading Edge Ventures LLC · Pompano Beach, FLBuilt 1991 · S/N CE-1557N595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeBuilt 1979 · S/N TJ-189N5981BCollins Gordon Lee Jr · Knoxville, TNBuilt 1980 · S/N E-1776N599WB7r Leasing LLC · Wilmington, DEBuilt 1988 · S/N CE-1272N59BQMod Flying LLC · Elkhorn, NES/N E-2273N59CMCalled To Care Residential Facility LLC · Goodyear, AZBuilt 1979 · S/N E-1377N59CTTornado Alley Turbo Inc · Ada, OKBuilt 1980 · S/N E-1719N59GMBerry Frank C · Watkinsville, GABuilt 1981 · S/N CE-964N59HMBaron International Ventures LLC · West Palm Beach, FLBuilt 1975 · S/N TH-635N59JBAero Buelo LLC · Jasper, TXBuilt 1982 · S/N E-2045N59KJSpike LLC · Cheyenne, WYBuilt 1993 · S/N EA-549N59PJTad Holdings LLC · Little Falls, MNBuilt 1987 · S/N E-2395N59TATailwinds Air Inc · Morganza, LABuilt 1997 · S/N EA-606N5ALSchapansky Justin · Mount Airy, GABuilt 1973 · S/N TH-356N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315N5BZBad Bird LLC · Elon, NCBuilt 1975 · S/N TH-662N5CKPhlyx Aviation · Edgewater, MDS/N D-9693N5DCSturges Jason Charles · Phoenix, AZBuilt 1976 · S/N E-887N5DLAmerson Loyd Scott · Douglas, GABuilt 1979 · S/N E-1515N5FWWord Forrest R · San Antonio, TXBuilt 1979 · S/N TE-1167N5GKPacific Air Investments LLC · Paso Robles, CABuilt 1975 · S/N D-9831N5GWJayne John E · Hanover, NHBuilt 1987 · S/N CE1197N5HCPut A Lid On It Palm Beach Inc · Jupiter, FLBuilt 1972 · S/N D-9347N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251N5QBPayne Thomas H · Tulsa, OKBuilt 1979 · S/N D-10246N5VBCustom Fire Apparatus Inc · Osceola, WIBuilt 1980 · S/N TE-1179N5VLLange Vladimir · Santa Ana, CABuilt 1979 · S/N D-10223N5WADenver Timothy Arthur · Gardnerville, NVBuilt 1973 · S/N TE-903N5WFMociva Inc · Del Mar, CABuilt 1994 · S/N E-2892N5WMMerrell Warren · Idalou, TXBuilt 1975 · S/N E-649N5XLLove John R · Sutton, MABuilt 1972 · S/N D-9334N5ZRBeasley Timber Co Inc · Hazlehurst, GABuilt 2005 · S/N TH-2128N600AFClark Development LLC · Dekalb, ILBuilt 1980 · S/N E-1803N600BBGat Air & Ground LLC · Norwich, NYFirst renewal noticeBuilt 1981 · S/N TH-1236N600CTRutner Stephen M · Palm City, FLS/N E-2979N600GDAlpha Mike LLC · Stoughton, MAS/N E3561N600MSInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N E-995N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250N600RVAero-Tech Services Inc · Lititz, PABuilt 1998 · S/N TH-1854N600ZZGsair Inc · Wilmington, DEBuilt 1973 · S/N E-400N6012SWhaley Carl S · Shelby, NCS/N TJ-15N6017SEisma Thomas Eugene · Golden, COBuilt 1975 · S/N TJ-17N6018SJohnson Thomas G · New Port Richey, FLS/N TJ-19N601BTCoats George A · The Woodlands, TXBuilt 1989 · S/N CE-1371N601SWDynaero LLC · South Vineland, NJBuilt 1976 · S/N E904N6023QCr Mcdowell Construction Co Inc · Keokuk, IABuilt 1979 · S/N E-1441N6023UHigh Scott · Albuquerque, NMBuilt 1979 · S/N E-1442N6023ZSchmauderer Ivan K · Woodland, CABuilt 1979 · S/N E-1468N6024AAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N D-10210
Back to AD 87-18-06 R1