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.

N4673NSimla Properties LLC · Casa Grande, AZBuilt 1979 · S/N 18266848N4673SGear Up Aviation LLC · Yukon, OKBuilt 1975 · S/N E-768N4673UStephl Chris L · Soldotna, AKBuilt 1964 · S/N 18051372N4674EMilliken Bradley B · San Mateo, CABuilt 1982 · S/N 18268258N4674MPerpetual Rkm LLC · Kalispell, MTBuilt 1978 · S/N TC-2154N4674NBorderline Sky LLC · El Paso, TXBuilt 1980 · S/N 340A1023N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802N4675CLane Robert W · Palmer, AKBuilt 1974 · S/N 18502592N4675ERojo Aircraft LLC · Mesquite, NVBuilt 1982 · S/N 18268259N4676BRobbins J Putnam · Valparaiso, INBuilt 1955 · S/N 31574N4677DHorton Richard F · Los Lunas, NMBuilt 1957 · S/N D-4909N4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNBuilt 1978 · S/N 414A0068N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577N4678AIflyjctc82 LLC · Macomb, ILBuilt 1970 · S/N E-229N4678BKing Paul E · Albany, ORBuilt 1955 · S/N 31576N4678DKennedy Kevin L · Moscow, IDBuilt 1956 · S/N D-4902N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278N4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1975 · S/N 18263679N4678QPrairie Dog Aviation LLC · Sioux Falls, SDBuilt 1972 · S/N 21059578N4679AFlying Bulldogs LLC · Joplin, MOBuilt 1956 · S/N 32276N4679UNelson Ross R · Menomonie, WIBuilt 1964 · S/N 18051379N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983N467CCOld South Construction Of Tennessee LLC · Franklin, TNBuilt 2022 · S/N 8619N467CDStarship 1 LLC · Houston, TXBuilt 2005 · S/N 1439N467DBParamont Services Inc · Newbury Park, CABuilt 1978 · S/N 340A0467N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142N467PSNeuwirth Robert · Gillette, WYBuilt 2007 · S/N 29-0481N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475N467TWiley Barbara · Yellow Springs, OHBuilt 1960 · S/N TC-39N467WFSanstone Aviation LLC · Arden, NCBuilt 2024 · S/N 9840N4680DSmith Larry D · Friendswood, TXBuilt 1957 · S/N D-4889N4680KIntrepid Red Baron Inc · New Franken, WIBuilt 1975 · S/N 18263681N4680NRentz Communications Inc · New Smyrna Beach, FLBuilt 1978 · S/N 414A0070N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814N4680UFoster Randy · La Grange, TXBuilt 1964 · S/N 18051380N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281N4681KBluestone Ryan Joseph · Lake Havasu City, AZBuilt 1975 · S/N 18263682N4682UWaddoups Max E III · Palmer, AKBuilt 1964 · S/N 18051382N4683DAdolph David J · Everly, IAS/N D-4868N4683KKrohn Ronald C · Pauma Valley, CABuilt 1975 · S/N 18263684N4684AShilanski Micah V · Wasilla, AKBuilt 1956 · S/N 32281N4685ARegistered aircraftBuilt 1956 · S/N 32282N4685DTopaz Adventures LLC · Rockport, MEBuilt 1956 · S/N D-4895N4685FRulewicz Dennis G · Jackson, MIBuilt 1966 · S/N P206-0285N4685MCbh LLC · Madison, CTBuilt 1978 · S/N D-10143N4686BThompson Harrison C · Brookings, SDBuilt 1955 · S/N 31584N4686DGarmashov Yuriy · Happy Valley, ORBuilt 1956 · S/N D-4891N4686KMcdonald Robert M · Oak Point, TXBuilt 1975 · S/N 18263687N4687AMorris Equipment LLC · Yuma, AZS/N 32284N4688AKnutson Ronald J · Tacoma, WABuilt 1970 · S/N D-9183
Back to AD 2000-23-21