OpenAirDocs.org
AD 98-17-01 R1

Registered aircraft · 1,201

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:98-17-01-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:98-17-01-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.

N888CPN888cp Aviation Corp · Wilmington, DEBuilt 1988 · S/N 31-003N888UPTeam Aero LLC · Shawnee, KSBuilt 1981 · S/N 465-68N889CAGracon Express LLC · Lafayette, COBuilt 2001 · S/N 132N890ACDodson Intenrational Parts Inc · Rantoul, KSBuilt 1983 · S/N 92N890LTLife Time Inc · Chanhassen, MNBuilt 1997 · S/N 19N891SHHulfe Air LLC · Caguas, PRBuilt 1991 · S/N 650-0210N892TXByte Me Transportation Inc · Fort Pierce, FLBuilt 2002 · S/N 258592N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354N897ACoastal Greens Aviation LLC · Myrtle Beach, SCBuilt 1997 · S/N 258326N89TBAir Med Capital LLC · Kissimmee, FLBuilt 1979 · S/N 272N89WABurris D Rob Trustee · Tucson, AZBuilt 1999 · S/N 258420N8TGThunderun Aviation Corp · Glenwood, NYBuilt 1999 · S/N 190N900CQCequel III LLC · Saint Louis, MOBuilt 1998 · S/N 30N900DTega Air LLC · Bend, ORBuilt 1993 · S/N 131N900DMMwm Air LLC · Adrian, MIBuilt 1981 · S/N 358N900JTDbl Flight Services LLC · Dayton, OHBuilt 1982 · S/N 257147N900KEAbove The Rest Flying Services LLC · Midlothian, TXBuilt 1986 · S/N 052N900KUFalcon 900-91 LLC · Lewes, DEBuilt 1991 · S/N 91N900LPDoctair Inc · Mclean, VABuilt 1987 · S/N 20N900MKRacer X LLC · Chicago, ILBuilt 1988 · S/N 40N900NHNew Mfis Holdings LLC · Henderson, NVBuilt 2005 · S/N 157N900RLEib Equipment Leasing LLC · Naples, FLBuilt 2004 · S/N 131N900SNSn117 LLC · Great Neck, NYBuilt 2002 · S/N 117N900TEFalcon 900 LLC · Ocala, FLBuilt 1986 · S/N 12N900TNRegistered aircraftBuilt 1996 · S/N 158N900YBBold Access LLC · Leawood, KSBuilt 1987 · S/N 18N900YPVillages Equipment Co · Leesburg, FLBuilt 2002 · S/N 114N901LKBhb7 LLC · Vestavia, ALBuilt 1995 · S/N 650-7064N901MMUsonia Ventures LLC · Palo Alto, CABuilt 1997 · S/N 21N901RHBank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 650-0130N902AUAmafly LLC · Wilmington, DES/N 25N903CSHaus Of Suss LLC · Dallas, TXBuilt 1984 · S/N 138N903TBTres Borrachos LLC · Scottsdale, AZBuilt 2005 · S/N 155N904YPVillages Equipment Co · Leesburg, FLBuilt 2002 · S/N 104N905CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 005N907DFSummit View Aviation LLC · Aurora, ORBuilt 1987 · S/N 650-0120N907DPPrincess Flying LLC · Missoula, MTBuilt 1998 · S/N 100N907MCTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1997 · S/N 258340N908SBFalcon Hunter LLC · Houston, TXBuilt 2000 · S/N 81N909PMMason Aviation LLC · Aberdeen, WABuilt 1998 · S/N 176N909VJWc Aviation LLC · Gypsum, COBuilt 1981 · S/N 69N90AJBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 052N90ASVs Air LLC · Atlanta, GABuilt 1986 · S/N 650-0112N90FBLitton Global LLC · Wilmington, DEBuilt 2003 · S/N 258613N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75N90HCFalcon Aviation LLC · Jupiter, FLS/N 208N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180N90WPRegistered aircraftBuilt 2004 · S/N 258692N910KSAircraft Holding Solutions LLC · Newark, DEBuilt 1982 · S/N NA0328N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172
Back to AD 98-17-01 R1