Registered aircraft · 3,462

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.

N298KDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 100-0298 N299AVTeton Leasing LLC · Pocatello, IDBuilt 1999 · S/N BB-1680 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N299MKBoman & Kemp Manufacturing Inc · Ogden, UTBuilt 1990 · S/N BB1357 N299RPGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1537 N299VMSs Leasing LLC · Tulare, CABuilt 1986 · S/N LJ-1125 N29ANSouth Aero Inc · Albuquerque, NMBuilt 1999 · S/N 208B0753 N29MBluesky Geospatial Ltd · North Adams, MABuilt 1973 · S/N LW88 N29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0812 N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057 N2GGN2gg Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1539 N2MKItalian Job Holdings LLC · Johnstown, OHBuilt 2003 · S/N 1063 N2NCN C Dept Of Transportation · Raleigh, NCBuilt 2007 · S/N LJ-1855 N3000HNorth Florida Ag Services Inc · Lake City, FLBuilt 2012 · S/N T34-402 N30019O & K Aviation Inc · Newport, ARS/N T45007DC N3004WMiddle Georgia Aviation Inc · Cochran, GABuilt 1995 · S/N T42209DC N3006CNewkirk Thomas DBA · Garland, NCBuilt 2012 · S/N T34-403 N300AEColumbia Asset Trust Corp Trustee · Wichita, KSS/N 97 N300AWDavis Aviation Inc DBA · Brandon, MSBuilt 2004 · S/N LJ-1716 N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744 N300KAHeartland Aviation LLC · Ada, OKBuilt 1990 · S/N FL-28 N300PTGjf Enterprises Inc · Port Orange, FLBuilt 1984 · S/N FA-34 N300TMTaylor & Martin Enterprises Inc · Fremont, NEBuilt 1991 · S/N FL-50 N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319 N300WMWalker Manufacturing Co · Fort Collins, COBuilt 1988 · S/N FA156 N3011SH & H Flying Co · Finley, TNBuilt 2013 · S/N 402B-1276 N301CLWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 221 N3025PDakota Air Spray LLC · Huron, SDBuilt 2013 · S/N 502B-2896 N302JMEasy Air LLC · Wilmington, DEBuilt 2018 · S/N EVO-0082 N302MJ425 Partners LLC · Guymon, OKBuilt 1980 · S/N 425-0120 N302PCAerial Crop Protection Inc · Belle Glade, FLBuilt 2020 · S/N 502B-3267 N302PSF90x LLC · Modesto, CABuilt 1990 · S/N FA-213 N3030CWtas LLC · Dyersburg, TNBuilt 2013 · S/N 402B-1283 N3038PAgri-Tech Aviation Inc · Indianola, IABuilt 2013 · S/N 402B-1284 N30397Rust Raymond H III · Nacogdoches, TXBuilt 2003 · S/N 4697167 N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581 N303JWKey Investment Holdings LLC · Horseshoe Bay, TXBuilt 2002 · S/N 4697149 N303RRG2 Leasing LLC · Fargo, NDBuilt 1997 · S/N FL-178 N303TSCheyenne Air LLC · Ocean City, NJBuilt 1981 · S/N 31T-8166007 N30411Farm Air Inc · Astoria, ILBuilt 2014 · S/N 502B-2914 N3043VMccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-422 N3045HPesicka Theodore J · Hermiston, ORBuilt 2013 · S/N T34-411 N3045RCentral Ag Air LLC · Marion, KSBuilt 2013 · S/N H80-140 N304JSRegistration Pending · Pharr, TXRegistration pendingBuilt 1988 · S/N FA142 N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495 N30523R & R Flight Service Inc · Mendota, ILBuilt 2013 · S/N 502B-2934 N3052KUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N UB-70 N3052VFederal Aerial Applicators LLC · Wilmington, DEBuilt 2012 · S/N T34-374 N30539Midwest Aerial Spraying LLC · Dorchester, NEBuilt 2013 · S/N 502B-2936 N3055MChorman Spraying LLC · Milton, DEBuilt 2012 · S/N T34-381

Back to AD 2002-23-13