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.

N1553KLl Aviation LLC · Hoover, ALBuilt 1988 · S/N E-2455N1553ZPierce Stephen J · Zebulon, NCBuilt 1990 · S/N E-2523N15549Hall Patrick D · Lakeway, TXBuilt 1990 · S/N CE1471N1554CTaggart Brent W · Hydro, OKBuilt 1953 · S/N 30254N1554FNovember 1554 Foxtrot LLC · Wilmington, DES/N 185-0921N1554GPhantom Air LLC · Lexington, NEBuilt 2007 · S/N 41785N1554SBeech Babe Ltd · Colorado Springs, COBuilt 1962 · S/N CD-525N1554TRegistration Pending · Tampa, FLRegistration pendingBuilt 1972 · S/N 414-0269N1555LGps Aviation LLC · Kennett, MOBuilt 1988 · S/N E-2419N1555WSmith John Albert Jr · Palm Coast, FLBuilt 1988 · S/N CE-1299N1555XShelton Brad · Wildwood, MOBuilt 1975 · S/N 34-7570284N1555YG E C Air LLC · Grove, OKBuilt 1989 · S/N E-2508N1556MC-Fleet LLC · Missoula, MTBuilt 1971 · S/N 18800656N1556TCalifornia Energy Exchange Corp · Rancho Cordova, CABuilt 1972 · S/N 414-0271N1556VSquires Daniel Douglas · Wakefield, RIBuilt 1976 · S/N R1722201N1557DB36tc LLC · Salinas, CAS/N EA-494N1557FFeaga Charles C Jr · Abbot, MEBuilt 1965 · S/N 185-0928N1557GAirperks LLC · Kalispell, MTBuilt 1974 · S/N 421B0653N1557TCessna 414 LLC · Lincoln, NEBuilt 1972 · S/N 414-0272N1557W557 Whiskey LLC · Superior, WIBuilt 1972 · S/N TH-229N1558ZAlpha Tango Aviation LLC · Gillette, WYBuilt 1961 · S/N CD-428N1559CHardee David B · Smyrna, TNBuilt 1953 · S/N 30259N1559FSchrage Timothy J · Anchorage, AKBuilt 1965 · S/N 185-0930N1559LLauritzen Clifton · Chowchilla, CAFirst renewal noticeBuilt 1976 · S/N CE-673N1559UDetmer Darren D · Chappell Hill, TXBuilt 1994 · S/N EA-557N155AGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N TC2311N155AJEuroaviation Inc Trustee · KematenBuilt 2007 · S/N 2439N155AZCoconino County Sheriffs Office · Flagstaff, AZBuilt 1980 · S/N 18267636N155BPooky Aviation LLC · Augusta, GABuilt 1958 · S/N D-5701N155CHK Top J Cattle Company LLC · Eldorado, TXBuilt 1968 · S/N CE-232N155DD M C Aviation LLC · Jennings, LABuilt 1954 · S/N 30701N155DGJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1983 · S/N 21064815N155DJCorder Farms Aviation LLC · Mcarthur, CABuilt 1966 · S/N 18257851N155DMHarden Aviation LLC · Washington, PABuilt 1978 · S/N 340A0511N155DSJk Diamond Star LLC · Hillside, ILBuilt 2006 · S/N 29-0444N155DVDunning Vineyards · Haines, ORS/N U20602985N155FRSpeed Aviation Holdings LLC · Lewes, DEBuilt 1970 · S/N TE-817N155JAStavrides Paul · Hartsville, PABuilt 1976 · S/N TC-1993N155JB2mec Holdings LLC · Kalispell, MTBuilt 1966 · S/N TC-1025N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837N155KKSmith Clifford Bryan · Newnan, GABuilt 1973 · S/N TC-1606N155KMMcintyre Kristen Alison · San Jose, CABuilt 2010 · S/N 0027N155KPGlen Stone Contruction Inc · Henderson, KYFirst renewal noticeS/N 18263197N155KTN155kt LLC · Dover, DEBuilt 1963 · S/N 21058196N155LUnderwood Robert · Waxahachie, TXBuilt 1968 · S/N TE-467N155LCAle & Quail Club LLC · Cheyenne, WYBuilt 1968 · S/N TE-615N155MVBernman LLC · Scarborough, MEBuilt 2015 · S/N 1101N155RCClark 155 LLC · Missoula, MTS/N 21064312N155SRSmedley Charles A · Medford, ORBuilt 2006 · S/N 1924N155STAzimi Shahram · Hayward, CABuilt 1964 · S/N TC-651
Back to AD 2000-23-21