OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N116HRegistration Pending · Kalispell, MTRegistration pendingBuilt 1964 · S/N TC-812N116HRRedpaw Aviation Ltd · Upper Arlington, OHBuilt 1986 · S/N 18268579N116JWAcvtg Aviation LLC · Wilmington, DEBuilt 1980 · S/N 335-0030N116KWE2e4 Labs LLC · Wilmington, DEBuilt 2003 · S/N 0732N116LLeavitt Mike · Kamas, UTBuilt 1964 · S/N TC-780N116LHC&L Holzwarth Inc · Virden, ILBuilt 1974 · S/N 18801815N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021N116SUBoolean Flight Sciences LLC · Mercer Island, WAS/N 18266668N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777N1170UBolton Bruce P · Monroe, LAS/N 25-0702N1170VPadgett Keith A · Bow, WABuilt 1976 · S/N R1722134N1171GGivich Daniel D · Park City, UTBuilt 1982 · S/N 25-0706N1171TCurrier Dustan A L · Fairbanks, AKS/N 30363N1172DPlaster James F · Winston Salem, NCBuilt 1953 · S/N 23220CN1172KDemo Salvage Inc · Calais, MEBuilt 1982 · S/N 25-0713N1173GN9337h LLC · Orlando, FLBuilt 1982 · S/N 25-0724N1173QMoon Mitchell L · Covington, GAS/N 21059673N1173WScupham R K · West Des Moines, IABuilt 1983 · S/N 25-0731N1174TDynamic Erp Resources Inc · Mansfield, TXBuilt 1975 · S/N TE-1056N1174X611 Yankee LLC · Chandler, AZBuilt 2013 · S/N T24002002N1175MRj Freebird LLC · Driftwood, TXBuilt 1975 · S/N 18264239N1175TCleared For The Option Aviation Services LLC · Kingwood, TXBuilt 1975 · S/N TH-604N1176XLyvers Joseph D · Louisville, KYBuilt 1975 · S/N 34-7570231N1177RN1177r LLC · Marshall, MIBuilt 1968 · S/N 18259162N1177SRoss Robert S · Pigeon, MIBuilt 1958 · S/N 50177N1178TDavis Aviation Group LLC · Gastonia, NCBuilt 1975 · S/N E-794N1178UWaco Diamond Star LLC · Niceville, FLS/N 21064671N1179TQuad Rabbit Inc · Wilmington, DEBuilt 1977 · S/N E-1124N117ACHayden Angela R · Sleetmute, AKBuilt 1968 · S/N 18258609N117AKBd Anesthesia LLC · Mineral Point, WIBuilt 2011 · S/N 0100N117BKBravo Kilo Capital LLC · Naples, FLBuilt 2021 · S/N 4999N117ECRambana & Ricci Pllc · Tallahassee, FLBuilt 1977 · S/N E-1118N117ESArctic Hauling LLC · Frankfort, ILBuilt 2022 · S/N 8531N117FDTush Mason Lee Jr · Sarasota, FLBuilt 2023 · S/N 9081N117FFRoaming Homes Inc · South Saint Paul, MNBuilt 1975 · S/N 18264383N117FLKinley Air LLC · Wilmington, DEBuilt 1979 · S/N TC-2226N117FPCross Timbers Holdings LLC · Dover, DEBuilt 2007 · S/N 42553N117GFive Bros Transportation LLC · Hobbs, NMBuilt 2009 · S/N 3464N117HCHm Aviation LLC · Lake Wales, FLBuilt 2025 · S/N 10640N117HLZosel Paul J · Bellingham, WABuilt 1976 · S/N 21061649N117JDVintage Motors Inc · Beattyville, KYBuilt 1967 · S/N 310L-0167N117KASouthern Latitude LLC · Alabaster, ALBuilt 1972 · S/N TE-852N117KCElektra Air LLC · New York, NYBuilt 2017 · S/N 4536N117KDCirrus Pompano Flyers Inc · Fort Lauderdale, FLBuilt 2000 · S/N 1072N117KZRichards Robert · Waco, TXS/N 310Q0964N117LFD&E Aircraft LLC · Newark, OHBuilt 2012 · S/N 2148N117MMlp Recreation LLC · Lewes, DEBuilt 2023 · S/N 9249N117MEAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9221N117PCalvin Kyle · Wichita, KSBuilt 1976 · S/N 21061407
Back to AD 2000-23-21