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

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

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.

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

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.

N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200SGJacks Wings LLC · Boca Raton, FLS/N 239 N200WKSkyview LLC · Wilmington, DEBuilt 1976 · S/N 261 N202AVAvista Corp · Spokane, WABuilt 1999 · S/N 650-7108 N202JKRosado Aviation Inc · Moosic, PABuilt 1985 · S/N 650-0100 N202LGLegacy 20 Enterprises LLC · Wilmington, DEBuilt 2000 · S/N 258454 N202WRDumont Associates Inc · Morris Plains, NJBuilt 1987 · S/N 24 N2033Aircraft Holding Solutions LLC Trustee · Newark, DES/N 258093 N204BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1990 · S/N 650-0189 N204RTCalifornia Motorsports Group Inc · San Diego, CABuilt 2000 · S/N 204 N207BCFalcon Crest Holdings LLC · Dallas, TXBuilt 1997 · S/N 093 N209CQFalcon 900ex Msn 98 LLC · New Castle, DEBuilt 2001 · S/N 98 N20CRWestern Air International Corp · Fort Lauderdale, FLBuilt 1983 · S/N 097 N20GJGlobal Jetcare Inc · Brooksville, FLS/N 026 N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113 N20GXWide Open Skies Viii LLC · Belgrade, MTBuilt 1981 · S/N 131914 N20PJAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 258275 N20XPVenture Jets LLC · Lititz, PABuilt 2000 · S/N 197 N211ECEast Coast Flight Services Inc · Easton, MDBuilt 1980 · S/N 166 N211GSInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 021 N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093 N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073 N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332 N217MJMtk Leasing LLC · Woodburn, ORBuilt 2002 · S/N 217 N217PTVapor Air LLC · Camden, DEBuilt 1986 · S/N 163 N218NBDavid L Samani Md Inc · Lincoln, NEBuilt 1998 · S/N 146 N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426 N218RXAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1996 · S/N 258323 N21HMIheartmedia Management Services Inc · New York, NYBuilt 1988 · S/N 41 N21HRJetsteam Aviation Inc · Cheyenne, WYRegistration ineffective or invalidBuilt 1981 · S/N 335 N220CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 120 N220PFExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 258542 N222MULanier Air East Coast LLC · Pineville, NCBuilt 1980 · S/N 164 N222NEHigher Cause LLC · Grand Rapids, MIBuilt 2000 · S/N 110 N222PBBlanchard Aviation LLC · Albuquerque, NMBuilt 1999 · S/N 258443 N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279 N227GJAsi Holdings Inc · New Castle, DEBuilt 1987 · S/N 182 N229DN229d LLC · Stuart, FLBuilt 1985 · S/N 427 N229LJN229lj LLC · Bentonville, ARBuilt 2001 · S/N 229 N22AVAvalair Aircraft Management LLC · Houston, TXBuilt 1980 · S/N 304 N22CPRegistered aircraftBuilt 2003 · S/N 258624 N232CEN232ce LLC · Newberry, FLBuilt 1984 · S/N 650-0067 N232TAAviation Trading Partners LLC · Shawnee, KSS/N 650-0128 N233KCMp Air LLC · Eagle Point, ORBuilt 1998 · S/N 48 N235LJMango Aviation Parts LLC · Plantation, FLS/N 297 N238AXFabio Lopez · Denver, NCS/N 030 N238DBLewis University · Romeoville, ILBuilt 1977 · S/N 215 N238LMBcp Fa Ap LLC · Providence, RIBuilt 1999 · S/N 039 N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39 N239CASantiago Communities Inc · Orange, CABuilt 1996 · S/N 126

Back to AD 82-23-03 R1