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.

N305ATAircraft Trustee Services Inc Trustee · Dover, DES/N 504-4005 N305ELRoper Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB947 N305LAShores Ag-Air Inc · Corpus Christi, TXBuilt 2014 · S/N 402B-1305 N305ZAZulu Air LLC · Opa Locka, FLBuilt 1996 · S/N LJ-1439 N30601Longwood Flying Service Inc · Hollandale, MSBuilt 2012 · S/N T34-400 N3060DMcelwain Russell · Lancaster, KSBuilt 2012 · S/N T34-383 N30620Mccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-407 N3063HBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 502B-2943 N3066VMurtagh Flying Service Inc · Lexington, MSBuilt 2014 · S/N 502B-2965 N3066WFortis Aircraft Leasing LLC · Reno, NVBuilt 1998 · S/N LJ-1536 N3067WMg37 Investments LLC · Holdrege, NEBuilt 2014 · S/N 502B-2977 N3067XSamson Ag Flying LLC DBA · Wilmington, DEBuilt 2006 · S/N T34-278 N3070GWilliamsburg Air Service Inc · Kingstree, SCBuilt 2013 · S/N 402B-1303 N3071KAurora Cooperative Elevator Co · Aurora, NEBuilt 2015 · S/N 502B-3014 N3071WWood Flying Inc · Panhandle, TXBuilt 2014 · S/N 502B-3009 N3072FGreat Plains Application LLC · Slayton, MNBuilt 2014 · S/N 502B-2999 N3073CCentral Plains Spraying Inc · Hart, TXBuilt 2014 · S/N 502B-3015 N3074FDeterding James L DBA · Pond Creek, OKBuilt 2014 · S/N 502B-3006 N3075D49 Flying Service LLC · Greenwood, MSBuilt 2015 · S/N 502B-3016 N3076HPost Rock Aviation Inc · Lincoln, KSBuilt 2015 · S/N 502B-3017 N3076WRba LLC · Kimberly, IDBuilt 2015 · S/N 502B-3024 N3078TBarts Flying Service Inc · Storm Lake, IABuilt 2015 · S/N 502B-3027 N307RWRomeo Whiskey LLC · Klamath Falls, ORBuilt 2017 · S/N 100-0230 N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781 N307YPVillages Equipment Co · Leesburg, FLBuilt 2024 · S/N 100-0340 N3080FGreyhawk Aviation LLC · Ketchum, IDBuilt 1999 · S/N FL-249 N3081YJefferson Davis Parish Mosquito · Jennings, LABuilt 2015 · S/N 504-4027 N30832Bank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 502B-3039 N30898Painter Andrew S · Harlingen, TXBuilt 2005 · S/N 4697202 N308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N LJ-1478 N308MDGem City Properties LLC · Laramie, WYBuilt 1990 · S/N LJ1246 N308RMN308rm LLC · Boca Raton, FLBuilt 1974 · S/N LJ628 N3096PV V I P LLC · Cottonwood, AZBuilt 2004 · S/N 4697178 N3098365 Whiskey Romeo LLC · Timnath, COBuilt 2004 · S/N 4697189 N309CQFelicidad Holdings LLC · Winter Springs, FLBuilt 2018 · S/N 100-0260 N309LTLebeouf Bros Towing LLC · Bourg, LABuilt 2021 · S/N 100-0294 N30BEEllingson Craig Edward Trustee · Clive, IABuilt 2021 · S/N 4698194 N30CCTalon Air Services Inc · Soldotna, AKBuilt 1964 · S/N 1566TB4 N30EAEagle Air Transport Inc · Ottawa, ILBuilt 1968 · S/N 191 N30HVCustom Fabricating & Repair Inc · Marshfield, WIBuilt 1989 · S/N FA-173 N3104WBirch Tree Aviation LLC · Unadilla, GABuilt 1990 · S/N T34-151 N3104YCrop Dusters LLC · Maurice, IABuilt 1991 · S/N T34-156 N3105EJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T34-177 N31062Central Virginia Aviation Inc · Petersburg, VABuilt 2005 · S/N 4697208 N310JKConnors Air Holdings LLC · Tierra Verde, FLBuilt 2001 · S/N 4697069 N3110TWellborn Aviation LLC · Texarkana, TXBuilt 2005 · S/N 4697221 N3117SBlue Horseshoe LLC · Brentwood, TNBuilt 2005 · S/N 4697230 N3117VP&C Aircraft LLC · Chapel Hill, NCBuilt 2005 · S/N 4697234 N311GCRte Enterprises Inc · Canoga Park, CABuilt 1980 · S/N LA-55 N311KDTriple C Charters LLC · Carmel, INBuilt 2022 · S/N 100-0311

Back to AD 2002-23-13