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.

N153KDMec International Trading LLC · Mission, TXBuilt 1968 · S/N 153 N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153 N153SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2002 · S/N 1054 N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171 N1544RRas Aviation LLC · Elyria, OHBuilt 1992 · S/N 401-0864 N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366 N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N154CLAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0212 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N154NPSisk Douglass F Trustee · Oakhurst, CABuilt 2019 · S/N 100-0262 N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204 N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206 N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214 N1556WPrecissi Flying Service Inc · Lodi, CAFirst renewal noticeBuilt 1992 · S/N 502-0185 N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884 N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175 N1558URba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0188 N155CJUe-55 LLC · Helena, MTS/N UE-55 N155CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0127 N155KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 100-0155 N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069 N155RSTms Consulting LLC · Anderson, SCBuilt 2006 · S/N LJ-1804 N155SYRocky Mountain Aviation LLC · Aberdeen, IDBuilt 1992 · S/N 1013 N155VVVolatile Aero Ventures LLC · Boulder City, NVBuilt 2009 · S/N 155 N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156 N156PCIdaho Skyworks LLC · Walnut Creek, CABuilt 1976 · S/N 777 N157CLSnowy Butte Air Ships LLC · Eagle Point, ORBuilt 2015 · S/N 100-0157 N157LAWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0157 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157 N157STAllen Family Aviation LLC · Haines, ORBuilt 2023 · S/N 4698280 N158CLUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 58 N158JMad River LLC · Lenox, MABuilt 2007 · S/N LJ-1859 N158KQGuardian Angel Homes LLC · Hayden, IDBuilt 2015 · S/N 100-0158 N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333 N159ZZBrown Helicopter Inc · Pensacola, FLBuilt 2010 · S/N LJ-1991 N16Federal Aviation Administration · Oklahoma City, OKBuilt 2010 · S/N LJ-1994 N160KQMjolhus Knut G · Amarillo, TXBuilt 2015 · S/N 100-0160 N160RWRitch Air LLC · Visalia, CABuilt 1998 · S/N FL-226 N160SMAviation Star S LLC · Beaumont, TXBuilt 1998 · S/N FL-215 N160ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0227 N161KQPenridge Aviation LLC · Portland, ORBuilt 2015 · S/N 100-0161 N162DETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 429 N162GAPa1 208b-0667 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0667 N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137 N162PBPapa Bravo Aviation LLC · Fort Lauderdale, FLBuilt 1996 · S/N 162 N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104 N163KAAdvanced Global Services Inc · Vero Beach, FLBuilt 2024 · S/N 46020016 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655 N165TGAmj Aviation LLC · Oneida, TNBuilt 1997 · S/N FL-165

Back to AD 2002-23-13