Registered aircraft · 3,461

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

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:2002-23-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13') ORDER BY n_number

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:2002-23-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
  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.

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:2002-23-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N143VHVan Horn David · Lynnwood, WABuilt 2019 · S/N EVO-0086 N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437 N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49 N144JTFlight 1976 LLC · Kennesaw, GABuilt 1999 · S/N 144 N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640 N1455TKenmore Air Harbor LLC · Kenmore, WAS/N 1647TB26 N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N146SLDodson International Parts Inc · Rantoul, KSS/N 1091 N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813 N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476 N148SAZuni LLC · Kirkland, WAS/N 409 N148SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 504-4044 N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N149MFMercy Flights Inc · Medford, ORBuilt 2018 · S/N LJ-2151 N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149 N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149 N149SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 504-4045 N14GVScott T LLC · Portland, ORS/N 4697092 N14RPAs350 LLC · Missoula, MTBuilt 2024 · S/N 100-0338 N1500EVaughans Aircraft Leasing LLC · Claremore, OKS/N 402-0820 N1502BAeroag LLC · Portland, INBuilt 1998 · S/N 502B-0476 N1502UCentral Ag Air LLC · Marion, KSBuilt 1991 · S/N 502-0139 N15054Air-Ag Inc · Tarboro, NCBuilt 1991 · S/N 402A-0823 N15074Wells Flying Services LLC · Holdrege, NEBuilt 1991 · S/N 402A-0825 N1507KDakota Air Spray LLC · Huron, SDBuilt 1991 · S/N 502-0142 N150ACJohnson Airspray Inc · Argyle, MNBuilt 1991 · S/N T34-150 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N150KReilly John P · Friendsville, PABuilt 2011 · S/N 100-0051 N15102Moes Crop Dusting Service Inc · Marysville, CABuilt 1991 · S/N 502-0146 N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152 N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155 N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837 N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156 N151BCBrc Az Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 100-0289 N151CAAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3653 N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083 N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838 N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840 N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161 N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158 N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849 N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182 N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850 N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002 N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847 N1534DEdge Aviation LLC · Moberly, MOBuilt 1992 · S/N 402A-0855 N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153

Back to AD 2002-23-13