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.

N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N147DTGabriella Elena Inc · Winnetka, ILBuilt 1998 · S/N E-3163N147PN147p LLC · Wilkesboro, NCBuilt 1979 · S/N CE-868N147PWBarr Tammy D · Spicewood, TXBuilt 2001 · S/N E-3420N147WDDarroh Harold W · Richmond, TXBuilt 1979 · S/N TK-102N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161N149WLCarter Robert J Jr · Oak Ridge, TNS/N E3562N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062N14MNOne Room LLC · Abilene, TXBuilt 1978 · S/N E-1344N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14WWWa Consulting LLC · Nashville, TNS/N E-3297N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218N1516MWrubel David · Atlanta, GABuilt 1988 · S/N E-2459N15186N15186 LLC · Dyer, INBuilt 1988 · S/N E-2456N1520GFischer Kurt C · Lyme, CTBuilt 1988 · S/N CE-1283N1522LGoetz Dennis D · Mason, OHBuilt 1988 · S/N E-2457N1525WClark Josh D · Morehead, KYBuilt 1972 · S/N E-324N1526MGarmin At Inc · Salem, ORBuilt 1994 · S/N TH-1711N1526WSmith Neil Walter · Rincon, GABuilt 1972 · S/N TE-857N15278Zastrow Lyn · Prosper, TXBuilt 1990 · S/N E-2550N1527WRegistered aircraftBuilt 1972 · S/N D-9335N1528KBuck Daniel · Ashland, VABuilt 1988 · S/N E-2453N1529LSaso Martin P III · Elgin, ILBuilt 1994 · S/N CE-1771N1530WMather Aviation LLC · Rancho Cordova, CABuilt 1972 · S/N D-9338N1531WNeo Foot And Ankle Surgery Inc · Miami, OKBuilt 1972 · S/N E-325N1535WStark Gary · Riverside, CABuilt 1972 · S/N CE-374N1538GMiller Andrew D · Broomfield, COBuilt 1988 · S/N E-2465N1538HRobinson Manufacturing Inc · Rockford, ILBuilt 1988 · S/N E-2451N1539V39 Victor Aviation Inc · Macomb, ILBuilt 1989 · S/N E-2469N1539WM P W D Inc · Saint Charles, ILBuilt 1972 · S/N E-326N1541WGobogo LLC · Fort Collins, COBuilt 1972 · S/N E-327N15454Jb Transportation LLC · Peoria, AZBuilt 1990 · S/N CE-1489
Back to AD 87-18-06 R1