OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N4538FLohse Teal K · Cordova, AKBuilt 1966 · S/N 185-1025N453BBBass Equipment LLC · Texarkana, ARBuilt 2016 · S/N TH-2453N453CDGizelbach Anthony · Newnan, GABuilt 2004 · S/N 1453N453MCMcneil Kenneth A · Fort Meade, FLS/N 21059844N453MFSpain William D Jr · Mahopac, NYBuilt 1995 · S/N 29-0069N453SAHts LLC · Hudsonville, MIBuilt 2002 · S/N E-3453N4540Mathis Mark L · Fremont, CABuilt 1971 · S/N E-299N4540STdc Aviation LLC · Wilmington, DES/N TC-1891N4542BWilliamson Charles F · Ocean Isle Beach, NCBuilt 1955 · S/N 31441N4543BGrandy Glen E · Placerville, CABuilt 1955 · S/N 31442N45456Oakhill Aviation LLC · Wasilla, AKBuilt 1956 · S/N 33809N4545BTwist Air Inc · Overland Park, KSBuilt 2015 · S/N 29-0520N4545MSimplifly Aviation LLC · Elon, NCBuilt 1978 · S/N TH-914N4546FThomas Craig E · Stevensville, MTBuilt 1966 · S/N 185-1039N4546QHarlow Jack M · Benbrook, TXBuilt 1973 · S/N 310Q0728N4546SMid Iowa Equipment · Newton, IABuilt 1975 · S/N TC-1895N4547MOxly Aviation LLC · Wilmington, DEBuilt 1978 · S/N TH-915N4547SLorentz Aviation LLC · Canadian, TXBuilt 1976 · S/N TJ-81N4548BSchad Anthony J · Oceanside, CABuilt 1955 · S/N 31447N4548FWard Nelson H · Salcha, AKBuilt 1966 · S/N 185-1043N4549FMetroaire LLC · Mc Kees Rocks, PABuilt 1966 · S/N 185-1045N454ATye Eric R · Napa, CABuilt 1963 · S/N TC-533N454AKClum David V · Anchorage, AKBuilt 2014 · S/N 0001N454BWWheeler Jonathan R · Idaho Falls, IDBuilt 2019 · S/N 783N454CPWestern Chancellor LLC · Fort Worth, TXBuilt 2008 · S/N 3303N454GGAk Air Leasing LLC · Homer, AKBuilt 1981 · S/N U20606487N454JDickey Michael W · Fredericksburg, TXBuilt 1979 · S/N E-1571N454MCGc Aviation LLC · Arden, NCBuilt 2008 · S/N 411016N454MKSuttle Carl · San Jose, CABuilt 2004 · S/N 1447N454RBDan Cox LLC · Troutdale, ORBuilt 1966 · S/N D-8242N454RCRcr Aviation LLC · Cartersville, GABuilt 2017 · S/N 1624N454RKFiore Christopher · Forked River, NJS/N 2084N454SDDelcampo Holdings LLC · Atlanta, GABuilt 2008 · S/N 3114N454SPSps Investment Properties LLC · Macon, GABuilt 1980 · S/N 414A0626N454SRFaisal Tameesh · Sterling Heights, MIBuilt 2007 · S/N 2428N454SVEcliax LLC · Craig, AKBuilt 1981 · S/N U20606524N4550BHickle William H · Inyokern, CABuilt 1955 · S/N 31449N4550QIsland Wings Inc · Fort Lauderdale, FLBuilt 1969 · S/N 402A0050N4551SAak Enterprises LLC · Fayetteville, ARFirst renewal noticeBuilt 1976 · S/N CE-645N4553SMinion Air Inc · John Day, ORBuilt 1968 · S/N 18259182N4554FFejes Jacob J · Watertown, NYS/N 185-1057N4555Glass Bagging Ent Inc · Duncansville, PABuilt 2008 · S/N 3312N4556MPerry Richard H · Crossville, TNBuilt 1978 · S/N E-1234N4557FKincaid Jonathan A · Frankfort, MEBuilt 1966 · S/N 185-1061N4557NWestra Aviation LLC · Beaver Dam, WIBuilt 1978 · S/N 340A0547N4558BDe Ley Taylor · Yorba Linda, CABuilt 1955 · S/N 31457N4558FN4558f LLC · Columbus, OHBuilt 1966 · S/N 185-1062N4558KRankin Gary L · Vancouver, WABuilt 1948 · S/N NAV-4-1558N4559MSky High Ventures LLC · Bartlett, TNS/N E-1235N455AH.5 Moon LLC · Cheyenne, WYBuilt 2019 · S/N XLFG505
Back to AD 2000-23-21