OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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
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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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.

N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186N2241TWhittock Tyson H · Anchorage, AKS/N 185-1397N2242GNelson Mark · Fairbanks, AKBuilt 1958 · S/N 51542N2242WKikhtenko Dmytro · Horse Shoe, NCBuilt 2025 · S/N 10831N2243CBelleville Livestock Market Inc · Belleville, PABuilt 1953 · S/N 30543N2243NBarclay Alexander C · Seattle, WABuilt 1979 · S/N 28R-7931052N2243XSmith Debra A · Louisville, KYS/N 337-0143N2243ZWashington Israel · Cincinnati, OHBuilt 1979 · S/N 28R-7931189N2244ASw Adventures LLC · Las Vegas, NVBuilt 2024 · S/N 10232N2244BIntegrated Milk LLC · Dimmitt, TXBuilt 1978 · S/N 34-7970009N2244CSkywagon Aero LLC · Wilmington, DES/N 30544N2244FSky King 44f LLC · Florence, SCBuilt 1966 · S/N 310L-0044N2244GRichards Christopher · Austin, TXBuilt 2015 · S/N 1222N2244XPlane Life LLC · Wilmington, DEBuilt 1965 · S/N 337-0144N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754N2245CChesnut Lonnie R · Palmer, AKS/N 30545N2245GSkyair Express LLC · Overton, NVS/N 51545N2245ZFoder Troy E · Sunnyside, WABuilt 1976 · S/N 6172CN2246HHanover Flying Club LLC · Mechanicsville, VABuilt 2014 · S/N 4127N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396N2247RSkaggs Erik Jerome · Tupelo, MSBuilt 2017 · S/N 4534N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191N2249CHepburn Joseph · Towanda, KSBuilt 1953 · S/N 30549N2249GDelph Timothy M · Wasilla, AKBuilt 1958 · S/N 51549N2249MSky Visions Photography LLC · Manitowoc, WIFirst renewal noticeBuilt 1966 · S/N 310L-0049N2249NPatzer Emmons M · Palmetto, FLBuilt 1979 · S/N 28R-7931053N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193N224APowercat Aviation LLC · Yukon, OKBuilt 2018 · S/N 1810N224ABSkin LLC · Charlotte, NCBuilt 1992 · S/N CE-1680N224AJH4 Aviation LLC · Redding, CABuilt 2024 · S/N 10255N224ALAirborne Support Group LLC · Marion, MTBuilt 1963 · S/N 2050342N224ARAvtac Solutions LLC · Oneida, TNBuilt 2001 · S/N 0137N224AVAirplanesusa LLC · Schaumburg, ILS/N 2324N224BGSlo Cal Aviation LLC · Arroyo Grande, CABuilt 2017 · S/N 4469N224BTCacchiotti Lawrence F · Yakima, WABuilt 2002 · S/N 0370N224CAGas Aviation LLC · Elk City, OKBuilt 2010 · S/N TH-2279N224CDAaron Brothers · Hinsdale, MABuilt 2001 · S/N 1127N224CESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2016 · S/N 4396N224CFTitan Land Company LLC · Medford, ORS/N 2926N224CHMadden Jeffrey M · Queensbury, NYBuilt 1976 · S/N 18503075N224CKJett Aviation LLC · Orangeburg, SCBuilt 2013 · S/N 0603N224CTJust Go Man LLC · Scottsdale, AZBuilt 2011 · S/N 0105N224CZTeal Skies LLC · Wilmington, DEBuilt 2011 · S/N 3771N224DAAiralley LLC · Kingsport, TNBuilt 2008 · S/N 2988N224DDDe Maio Dorian Albert · Las Vegas, NVBuilt 2007 · S/N 2625N224DGFahrer Scott M · Sunrise Beach, MOBuilt 2002 · S/N 0275N224DLHagglund Carl · Pendleton, ORBuilt 1968 · S/N E-61N224DPBlue And Gold Aviation LLC · Marietta, OHBuilt 1991 · S/N E-2599N224DRN224dr LLC · Morristown, NJBuilt 2000 · S/N EA-660N224EBVasquez Aviation LLC · Lake Placid, FLBuilt 2005 · S/N 1287
Back to AD 2000-23-21