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.

N1076KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1461 N1079DGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1462 N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N107CANorth Applicair Corp · Panama City Beach, FLBuilt 1988 · S/N R1340011 N107KAN107ka Inc · Addison, TXBuilt 2005 · S/N 208B1107 N107KQJsc Rentals LLC · Missoula, MTBuilt 2014 · S/N 100-0107 N107MLMike Ogan Farms · Pierre, SDBuilt 2012 · S/N 402B-1250 N107SLSouthwest Aviation Specialties LLC · Tulsa, OKFirst renewal noticeBuilt 2003 · S/N 1073 N1083SGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1443 N1086FAvion Capital Corp · Anchorage, AKBuilt 1995 · S/N 208B0436 N108MKMikelly Aircraft LLC · Portland, ORBuilt 2017 · S/N EVO-0078 N108TFWood Flying Inc · Panhandle, TXBuilt 2008 · S/N 502B-2652 N1095WEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1456 N109CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0060 N109MDM B Duncan Inc · Bakersfield, CABuilt 1985 · S/N BB-1213 N109MSCavallino Rampante Inc · Dover, DEBuilt 1991 · S/N 1008 N109WTJe Kodiak 2018 LLC · Edina, MNBuilt 2018 · S/N 100-0246 N10DHVta Capital LLC · Ontario, CABuilt 1981 · S/N LA-111 N10EAEagle Air Transport Inc · Ottawa, ILS/N 199 N10GFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N LJ-1970 N10STGocc Blue Sky LLC · Augusta, GABuilt 2005 · S/N 4697220 N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310 N11Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1964 N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475 N110BHBighorn Flying Co LLC · Wood River, NEBuilt 2001 · S/N 402A-1135 N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481 N110XXMegair Ventures LLC · Oklahoma City, OKBuilt 2013 · S/N EVO-0045 N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486 N1114AEvans David J · Parker, COS/N 208B0309 N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559 N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514 N1115MPa1 208b-0356 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0356 N1116GAircraft Structures International Corp · Enid, OKBuilt 1994 · S/N 208B0402 N1117GBrylee Investment Corp · Wilmington, DEBuilt 1993 · S/N 208B0370 N1119VMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0383 N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6 N111JFJoyce Aviation Inc · Winston Salem, NCBuilt 1981 · S/N 31T8120012 N111KULot-A-Go Six LLC · Polson, MTBuilt 1985 · S/N 425-0226 N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665 N111MZCrb Companies LLC · Tulsa, OKBuilt 1998 · S/N FL-210 N111RFEaston Air LLC · Middletown, RIBuilt 2003 · S/N 259 N111VRDftf LLC · Des Moines, IABuilt 1991 · S/N 1006 N111WGAhuva LLC · Port Alsworth, AKBuilt 2004 · S/N 555 N111XARegistered aircraftBuilt 2012 · S/N EVO-0035 N1120WMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0388 N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483 N1128LArne Aviation LLC · Suffolk, VABuilt 1996 · S/N 208B0536 N1129GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0924 N112HBRegistration Pending · Holdrege, NERegistration pendingBuilt 2012 · S/N 502B-2825 N112KQRondarosa Skybus LLC · Grangeville, IDBuilt 2014 · S/N 100-0112

Back to AD 2002-23-13