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.

N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LUDonalds Flying Service Inc · Pantego, NCBuilt 1998 · S/N T15-037DC N12MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 2024 · S/N 100-0342 N12WEN12we LLC · Lewes, DES/N LJ-1893 N13Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1968 N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N131SAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 46020113 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206 N1322TStrain Aviation LLC · Arbuckle, CABuilt 2015 · S/N 100-0135 N1323RWright Air Service Inc · Fairbanks, AKBuilt 1999 · S/N 208B0745 N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352 N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N132TJVertol Systems Company Inc · Destin, FLBuilt 2011 · S/N 173 N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321 N133KQValiair Lc Trustee · Casper, WYBuilt 2014 · S/N 100-0133 N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169 N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032 N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112 N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776 N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135 N135LTFleming William D · Litchfield, ILBuilt 1997 · S/N 135 N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551 N13642Visser Ag Inc · Rigby, IDBuilt 1999 · S/N 502B-0598 N136CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0037 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N1375FBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 402B-1375 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N138JMFull Throttle Aviation LLC · Clayton, DEBuilt 1991 · S/N 7 N139MCBilly Bobs Flying Service LLC · Bay, ARBuilt 2024 · S/N 510-139 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44 N13GXEpic II LLC · Reno, NVBuilt 2023 · S/N K040 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N13PFOdyssey Entertainment Inc · Maple Grove, MNBuilt 2011 · S/N EVO-028 N13SUDownwind LLC DBA · Salt Lake City, UTBuilt 2009 · S/N 152 N14Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1972 N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753 N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140 N141DZLiam 750 Inc · Charlevoix, MIBuilt 2008 · S/N XL 150 N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465 N141WPJb Family Enterprise LLC · San Jose, CABuilt 2014 · S/N EVO-0055 N1421ZMng Leasing LLC · Bottineau, NDBuilt 1998 · S/N 140 N142DVSalerno Robert J · Cornwall, NYBuilt 2015 · S/N 100-0142 N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217 N143AUSkydive Guam Inc · Barrigada, GUBuilt 2005 · S/N 125 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612

Back to AD 2002-23-13