OpenAirDocs.org
AD 82-23-03 R1

Registered aircraft · 1,185

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:82-23-03-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:82-23-03-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.

N900JTDbl 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 172N911GUTeam Aero LLC · Olathe, KSBuilt 1981 · S/N 343N913CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 013N913SCAircraft Holding Solutions LLC · Newark, DES/N NA0418N914ECPacific Rim Management LLC · Downey, CAS/N 258001N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915APAir Services Corp · Wilmington, DEBuilt 2002 · S/N 258574N917SMAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1998 · S/N 099N918XZAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1990 · S/N 258177N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313N91DPN91dp LLC · Dublin, OHBuilt 1993 · S/N 079N91GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 032N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N920EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258705N920RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 430N920TCHendershot Aviation LLC · Houston, TXBuilt 1996 · S/N 258291
Back to AD 82-23-03 R1