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.

N6648NMark & David LLC · Coldwater, MSBuilt 1979 · S/N D-10250N6649DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N TH-1041N6649LChauza Edward J · Mesa, AZBuilt 1979 · S/N E-1516N6649SRay James William · Albert, NMBuilt 1976 · S/N D-9847N664HWWilliamson Kemal · O Fallon, ILBuilt 1979 · S/N D-10260N664JGSpecialty Contractors Inc · Lake In The Hills, ILBuilt 1990 · S/N CE-1481N664TBechtol Andrew M · Long Beach, CABuilt 1972 · S/N D-9374N6650HN6650h LLC · Edmond, OKBuilt 1982 · S/N EA-318N6650LHoward Barron S · Henderson, NVS/N CE-866N66514Vintage Aviation Medical Associates LLC · Wilmington, DEBuilt 1979 · S/N E-1522N66518Daly Stephen M · Oakland, FLBuilt 1979 · S/N TH-1044N66519George Jon L · Gulf Shores, ALBuilt 1982 · S/N E-2054N66529King Warren D · Bend, ORBuilt 1979 · S/N EA-8N6652DRafter B Cattle Company LLC · Gordonville, TXBuilt 1979 · S/N D-10254N6652JAir Chairs LLC · Austin, TXBuilt 1979 · S/N EA-11N6652RDrummond Williams D · Bloomington, INBuilt 1979 · S/N E-1524N6652YSeiger Thomas W · Medford, ORS/N E-1525N66532Accu Spray LLC · Olton, TXBuilt 1983 · S/N EA-351N6653DWilliams Lee V · Dallas, TXS/N D-10256N6653RRegistered aircraftBuilt 1979 · S/N D-10259N6653VWalker Ray A · Sanger, TXBuilt 1979 · S/N D-10253N6654LRomeo Air LLC · Missoula, MTS/N EA-50N6654RLow Mach Aero LLC · Hays, KSBuilt 1979 · S/N D-10273N6654YLewis Garry L · Livingston, LABuilt 1979 · S/N TH-1061N6655QDurham Aviation LLC · Henrietta, TXS/N E-1740N6655YBretts Spray Service Inc · Onida, SDBuilt 1979 · S/N E-1559N66568Trapp Aviation Ltd · Lebanon, OHS/N TK-105N6656LAviation Solutions Group LLC · Royal Oak, MIBuilt 1979 · S/N CE-873N6656RHarris Walter D · Chatham, NJBuilt 1979 · S/N D-10275N6656WBonanza Partners Of Kc LLC · Shawnee, KSBuilt 1983 · S/N E-2075N6657TPilot-Ready LLC · Lime Springs, IABuilt 1979 · S/N EA-22N6657ZVas Incorporated · Reston, VABuilt 1979 · S/N CE-874N66585Haines Jay A · Summerland Key, FLBuilt 1983 · S/N EA-353N6658DThietten Gary L Trustee · Washington, UTBuilt 1979 · S/N D-10312N6658KEdelman Freddie L · Manlius, NYBuilt 1979 · S/N D-10278N6658SKgb58 Aviation LLC · Gibsonia, PAS/N TH-681N6658ZClark Lloyd E · Hanover, MDBuilt 1979 · S/N TJ-222N6659GGallentine Gene W · Clayton, KSBuilt 1979 · S/N CE-876N6659LControl Data Inc · Indianapolis, INBuilt 1979 · S/N D-10279N665JTN665jt LLC · Shoreline, WABuilt 1974 · S/N TE-990N66619West Bend Air Inc · West Bend, WIBuilt 1979 · S/N TH-1070N6661YSchlosser David · Scottsdale, AZBuilt 1979 · S/N TH-1068N6662HIrwin Dennis · San Diego, CABuilt 1979 · S/N D-10290N6662NRegistration Pending · Uvalde, TXRegistration pendingS/N TH-1073N6662TSeipp Edwin A III · Portola Valley, CABuilt 1979 · S/N D-10284N66648Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N D10289N6664LTt Aviation LLC · Oxnard, CABuilt 1979 · S/N EA-20N6665WIal Corp · Lewes, DEBuilt 1979 · S/N TJ-227N6665ZDunkley Music Inc · Meridian, IDBuilt 1979 · S/N D-10291N6666XBlack Sheep Aviation LLC · Palm City, FLBuilt 1979 · S/N TH-1093
Back to AD 87-18-06 R1