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.

N755EMSea Star Inc · Wetumpka, ALBuilt 2005 · S/N 661 N755FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0529 N756LARowland Dusters LLC · Raymondville, TXBuilt 2014 · S/N 502B-3005 N757BAWw Air LLC · Burwell, NEBuilt 1984 · S/N LJ-1097 N758United States Department Of The Interior · Boise, IDBuilt 2010 · S/N 100-0033 N7580BMec International Trading LLC · Daytona Beach, FLBuilt 1987 · S/N 208B0051 N7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1994 · S/N 208B0389 N758KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ316 N75AWSemper Blue Aviation LLC · New Braunfels, TXBuilt 1981 · S/N 42-8001046 N75GDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-83 N75LVCook Childrens Health Enterprises · Fort Worth, TXS/N BB-1075 N75LW4t Aviation LLC · Maypearl, TXBuilt 1973 · S/N LW-75 N75MSDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LA204 N75NDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-57 N75PGDasch Air LLC · Alamo, CABuilt 1995 · S/N LJ-1390 N75VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-103 N75ZDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-61 N760JEIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1997 · S/N 760462 N761CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1994 · S/N 760410 N761FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0254 N762FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0255 N763FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0256 N7644SIslander Holdings Ltd · Ft Lauderdale, FLS/N 760314 N765FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0259 N765LAAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2011 · S/N 502B-2740 N767FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0262 N767TPNuage Holdings LLC · Sioux Falls, SDBuilt 2001 · S/N 4697036 N768FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0263 N768SXRentco LLC · Deer Park, TXFirst renewal noticeBuilt 1991 · S/N 760372 N769United States Dept Of Interior · Boise, IDBuilt 2009 · S/N 100-0023 N769FXFederal Express Corp · Memphis, TNBuilt 2024 · S/N 408-0030 N769JSSpurlock Benjamin · Eugene, ORBuilt 2001 · S/N 187 N769PBAirworks LLC · Sabin, MNBuilt 2009 · S/N 502B-2691 N76AZHubbard Broadcasting · Saint Paul, MNBuilt 1988 · S/N 20800139 N76CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1989 · S/N 760355 N76DNFastboy Equipment LLC · Beasley, TXS/N 760351 N76EXIsland Express Helicopters Inc · Henderson, NVBuilt 1988 · S/N 760342 N76FLHelinet Aviation Services LLC · Van Nuys, CABuilt 1988 · S/N 760347 N76GMDodson International Parts Inc · Rantoul, KSS/N LJ-498 N76KAKenmore Air Harbor LLC · Kenmore, WABuilt 1958 · S/N 300 N76KQKodiak 100 LLC · Miami, FLBuilt 2012 · S/N 100-0076 N76LAMid-Continent Instrument Co Inc · Wichita, KSBuilt 2018 · S/N 100-0251 N76MGCook Brothers Farms LLC · Princeton, KYBuilt 2001 · S/N 4697056 N76PM2012 Leasing Inc · Saint Paul, MNBuilt 1998 · S/N FL-200 N76QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-15 N76SKFly High Aviation LLC · New York, NYBuilt 2011 · S/N EVO-003 N76XCHangar C-403 LLC · Walnut Creek, CABuilt 1985 · S/N 485 N770DCRam Aviation LLC · Alexandria, LABuilt 2000 · S/N 183 N770FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0265 N770FLTailwinds Aviation LLC · Wilmington, DEBuilt 2003 · S/N 501

Back to AD 2002-23-13