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.

N4621QFitzgerald Barry Eugene · Springfield, ILBuilt 1971 · S/N 21059521N4621TIrby Donald K · Cushing, TXBuilt 1965 · S/N 1033N4622AMyers Matthew D · Moody, TXBuilt 1956 · S/N 32220N4622NVmi Flight Co LLC · Roanoke, VABuilt 1979 · S/N 18267281N4622QBas Part Sales LLC · Greeley, COS/N 21059522N4623AHickle William H · Inyokern, CABuilt 1956 · S/N 32221N4623FHatfield William G · Nunica, MIBuilt 1966 · S/N P206-0223N4624KHoyt Matthew P · Newport Beach, CABuilt 1979 · S/N P21000243N4624QBowen Kennith M II Trustee · Winters, CABuilt 1971 · S/N 21059524N4624TEisel Adam A · Copenhagen, NYBuilt 1965 · S/N 1026N4624URuby Marine Inc · Nenana, AKBuilt 1963 · S/N 18051324N4625MSchuster Alexander · Santa Rosa, CABuilt 1978 · S/N E-1247N4625QBank Of Utah Trustee · Salt Lake City, UTBuilt 1971 · S/N 21059525N4625UFountain Trevin W · Junction City, ORBuilt 1963 · S/N 18051325N4626BRegistered aircraftBuilt 1955 · S/N 31524N4626DGoering Ryan I · Prineville, ORBuilt 1956 · S/N D-4779N4626FKrumpe Brothers LLC · Hagerstown, MDBuilt 1966 · S/N P206-0226N4626KWyeth Patrick B Trustee · Chino Valley, AZBuilt 1979 · S/N P21000244N4627BChapman Jeffrey C · Brownsburg, INBuilt 1955 · S/N 31525N4627KIsbell Brian · Rosenberg, TXBuilt 1979 · S/N P21000245N4627QMassey Larry A · New Braunfels, TXBuilt 1971 · S/N 21059527N4628BForsberg Ron A · Montrose, COBuilt 1955 · S/N 31526N46295Mangham C H · Mineral Wells, TXBuilt 1973 · S/N 18052410N46298Hodges Jay F · Fairbanks, AKBuilt 1974 · S/N 18052411N4629AHamlin Jeffrey T · Fall City, WABuilt 1956 · S/N 32227N4629FCandler Richard A · Sharpsburg, GABuilt 1966 · S/N P206-0229N4629KAuburn Farms LLC · Auburn, KSBuilt 1979 · S/N P21000247N462CAKinslow Aviation LLC · Prague, OKBuilt 2021 · S/N 2462N462CDSouth Fork Group LLC · Belmont, NCBuilt 2005 · S/N 1546N462CPPonozzo Donald A · Plainwell, MIBuilt 2008 · S/N 3275N462DATucker Leonard E II · Waller, TXBuilt 1968 · S/N 337-0950N462DLDanmar Leasing LLC · Little Rock, ARBuilt 2025 · S/N 10961N462DMAll In 1 LLC · Watford City, NDBuilt 1961 · S/N D-6848N462HSAmelia Ann Cruzing LLC · Sibley, LABuilt 2003 · S/N 0775N462MCCilliers Carlo R · Frederick, MDBuilt 2011 · S/N 1865N462PT4888 Aviation LLC · Peachtree Corners, GABuilt 2015 · S/N 4282N462TJJohnson River LLC · Durant, OKBuilt 2019 · S/N 1919N462WWPlane Metrics LLC · Fort Worth, TXBuilt 2001 · S/N LIV-462-SFBN46300Mason Steven O · Greenville, MEBuilt 1973 · S/N 18052413N4630KCorbin Rex W · Benton, KSBuilt 1975 · S/N 18263632N4630NHyannis Air Service Inc · Hyannis, MABuilt 1978 · S/N 402C0001N46317Mcvicker Andrew B · Erwinna, PABuilt 1974 · S/N 18052416N4631CGraves Martin · Odessa, TXBuilt 1979 · S/N 21063582N4631USpiro Paul M · Anchorage, AKBuilt 1963 · S/N 18051331N4632BRowbotham James · Martinez, CABuilt 1955 · S/N 31530N4633KBauer Aviation LLC · Sunbury, OHBuilt 1975 · S/N 18263635N4633MJ & S Aviation LLC · Clinton, MOS/N CE-816N4634ABrunner Lance C · Anchorage, AKBuilt 1956 · S/N 32232N4634BHehl Adam D · Anchorage, AKBuilt 1955 · S/N 31532N4634FCardinal Air LLC · Wynantskill, NYBuilt 1966 · S/N P206-0234
Back to AD 2000-23-21