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.

N346BGWebstrong Aviation LLC · Conway, ARBuilt 1973 · S/N D9494N346CBKombi Brazil Inc · Fort Lauderdale, FLS/N 21060712N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029N346DWValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 340A0742N346ENorth Coast Aeronautical LLC · Cleveland, OHBuilt 1984 · S/N EA-409N346FSRichard C Reed · Snyder, TXS/N 340A0790N346MCSkyway Aviation LLC · Purvis, MSS/N 340A-0425N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567N346S200 Knot LLC · Amarillo, TXBuilt 1969 · S/N D-9092N346ZRussell David B · Marion, ARBuilt 1960 · S/N CD-233N3470UThird Loop Partners · Paso Robles, CABuilt 1963 · S/N 18254870N3471FDel Norte Flying LLC · Del Norte, COBuilt 1966 · S/N 18257471N3471GPage Garrett A · Rhodes, MIBuilt 1976 · S/N 310R0845N3471SClint Woodword Construction LLC · Prineville, ORBuilt 1964 · S/N 18255871N3472FMiller Robert F · Locust Grove, GAS/N 18257472N3472GLosko Patrick J · Tustin, CABuilt 1976 · S/N 310R0846N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N3473RBrooks Gregory Keith · Green Cove Springs, FLBuilt 1967 · S/N 18258773N3473WGades Gary A · Montevideo, MNBuilt 1980 · S/N 18504080N3474YHanson Dan B Jr · Lusk, WYS/N 18051974N3475FSanguinetti Mark · Winnsboro, LAS/N 18257475N3475RMccullough Hugh J · Glennville, GABuilt 1968 · S/N 18258775N3475SSmith Reine K IV · Lockhart, TXBuilt 1965 · S/N 18255875N3476AIsaacs Eugene E · Key West, FLS/N CE-294N3476FDickens Charles L · Panama City Beach, FLS/N 18257476N3476RTibbs Properties LLC · Franklin, LABuilt 1968 · S/N 18258776N3476UNelson Robert D · Anchorage, AKBuilt 1963 · S/N 18254876N3477ARagsdale Lincoln J Jr · Phoenix, AZBuilt 1969 · S/N E-183N3477FFlying T LLC · Albuquerque, NMBuilt 1966 · S/N 18257477N3477SN3477s Inc · Dalton Gardens, IDS/N 18255877N3478QCsc Aviation LLC · Parker, COS/N 320E-0078N3479RM S Davidson Enterpries Pc · Laurel, DEBuilt 1968 · S/N 18258779N3479SCook Mark C · Hutto, TXBuilt 1964 · S/N 18255879N347AAci Aviation Holdings LLC · Abbeville, LABuilt 2017 · S/N 1541N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347N347CASouth Bay Air LLC · Romulus, MIS/N 411004N347CDCulkin Daniel J Trustee · Edmond, OKBuilt 2005 · S/N 1360N347CPNwr Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 3044N347DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2015 · S/N 1104N347JADepete Joseph G · Louisville, KYBuilt 1978 · S/N 340A0448N347JHJohn Harvey Pc · Savannah, GABuilt 1999 · S/N 1009N347SRVenture North Aviation LLC · Cloquet, MNBuilt 2007 · S/N 2575N347TMccartney Matthew T · Lake Tapps, WABuilt 1962 · S/N D-7058N347ZCasey John T · Shenandoah, TXBuilt 1960 · S/N CD-234N3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeBuilt 1966 · S/N 18257480N3480USoule Clauson D · Cooperstown, NYS/N 18254880N3481FWells Garry L · Scotia, NEBuilt 1966 · S/N 18257481N3481SDorman Richard E · Mesa, WABuilt 1964 · S/N 18255881N3481USmith Lowell A · Gresham, ORBuilt 1963 · S/N 18254881N3482UMitchell Philip T · Moreland, GABuilt 1963 · S/N 18254882
Back to AD 2000-23-21