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.

N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180N1669WBahri Kiumars · Birmingham, ALBuilt 1972 · S/N CE-392N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958N166PFroggatt Richard H · Sterling, MABuilt 1991 · S/N CE-1560N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N1684WHaller Philip L · Peoria, AZS/N D-9386N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389N1694WKlauber James S Sr · Boonsboro, MDBuilt 1972 · S/N E-363N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393N1697WMountcastle Creek LLC · Pratt, KSBuilt 1972 · S/N E-365N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392N1699WDkp Holdings LLC · Melbourne Beach, FLBuilt 1973 · S/N E-399N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N169TGNordic Sun LLC · Garner, NCBuilt 2005 · S/N E-3627N16CTOld Boys Aviation LLC · Knoxville, TNS/N CE-843N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16EJAlphaalpha Aviation LLC · Paragould, ARS/N E-3507N16NHRutgers Nicholas G IV · Camas, WABuilt 1985 · S/N E-2220N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N1701WJagz Aviation LLC · Akron, OHS/N D-9394N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303N1706WHinton Bay Management LLC · Jackson, WYBuilt 1972 · S/N E-366N1707WRussell Marc R · Simi Valley, CABuilt 1972 · S/N E-367N170HPKoven Mark Lee · Logan, UTBuilt 1975 · S/N CE-615N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N1717WAdkins Zachary R · Scottsboro, ALBuilt 1972 · S/N D-9368N171CEGarrison Randy · Queen City, TXBuilt 1973 · S/N E-504N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092N1725WEdwards John G · Stoneville, NCS/N D-9400N1731WCollins Air LLC · Kennett, MOBuilt 1972 · S/N E-369N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409N1748WBas Part Sales LLC · Greeley, COBuilt 1972 · S/N TE-887N174TATracewings LLC · Goodyear, AZS/N E-3499
Back to AD 87-18-06 R1