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.

N4634MLearned Doug · Corral De Tierra, CAS/N D-10122N4634U4634u LLC · Taylor, AZS/N U20605015N4635AHartman Gregory G · Eagle River, AKBuilt 1956 · S/N 32233N4635BBass Ronald · Cleveland, GABuilt 1955 · S/N 31533N4635GN535j LLC · Bismarck, NDBuilt 1977 · S/N 414-0906N4635KFinley Robert O · Dubois, WYBuilt 1976 · S/N R1722001N4636ARk Air LLC · Wilmington, DEBuilt 1956 · S/N 32234N4636BBernard David R · Sandy, UTBuilt 1955 · S/N 31534N4636KAdvanced Database Designs LLC · San Ramon, CABuilt 1979 · S/N P21000248N4637ALucky Dog Air LLC · Edmond, OKS/N D-9158N4637BTregeagle Richard D · Sandy, UTBuilt 1955 · S/N 31535N4637UWright Air Service Inc · Fairbanks, AKBuilt 1979 · S/N U20605017N4638ATropical Air Lease LLC · Hialeah, FLBuilt 1971 · S/N TC-1408N4638EMorelock Colleen P Trustee · Beavercreek, OHS/N 18503822N4638FSkydive Lake Tahoe LLC · Tahoe City, CABuilt 1966 · S/N P206-0238N4638KWiggins Air Patrol LLC · Wichita, KSS/N 18263640N4639BMoncrief Georgeanne H Trustee · Nampa, IDBuilt 1955 · S/N 31537N4639KMyers Gary L Trustee · Onida, SDBuilt 1975 · S/N 18263641N4639QGrundmann Karl · Manassas, VABuilt 1971 · S/N 21059539N463CZCzabaranek Joseph A · Bellevue, WAS/N LIV-063N463DPDouble Play Aviation LLC · Crossville, TNBuilt 2024 · S/N 10152N463GGriffin James Howard · Grapevine, TXBuilt 2007 · S/N 001N463KNg Aviation LLC · Dover, DEBuilt 1963 · S/N D-7290N463KJCc Equipment Holdings LLC · Zionsville, INBuilt 2022 · S/N 8605N463MAnssec LLC · Lake In The Hills, ILBuilt 1975 · S/N 18263661N463TCheck 6 LLC · Spearfish, SDBuilt 1963 · S/N D-7083N463VSDoctor Bad Ass LLC · Kalispell, MTBuilt 2015 · S/N T24002047N4640EState Of Utah · Salt Lake City, UTBuilt 1979 · S/N 18503824N4640FDouglas Mark S DBA · Bellingham, WABuilt 1966 · S/N P206-0240N4640GHonea Richard S · Canton, GABuilt 1976 · S/N 414-0908N4640KLarson Family Farms LLC · Haxtun, COBuilt 1975 · S/N 18263713N4641BKey James M · Hermiston, ORBuilt 1955 · S/N 31539N4642BRegister Edmond A · Tyler, TXBuilt 1955 · S/N 31540N4642UHolt John William · Tucson, AZFirst renewal noticeBuilt 1964 · S/N 18051342N4643BAnderson Charles D · Fairbanks, AKBuilt 1955 · S/N 31541N4644ALee Lauren M · West Greenwich, RIBuilt 1956 · S/N 32241N4644CMassmanf Darrel F · Ogdensburg, WIBuilt 1974 · S/N 18502585N4644FBrennan Timothy R Trustee · Mount Pleasant, SCBuilt 1966 · S/N P206-0244N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797N4645BJacobs Lydia A · Lincoln, MES/N 31543N4645KOrange Air Inc · Harbor City, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 18263647N4646ANorth Sixty Taildraggers LLC · Port Ludlow, WABuilt 1956 · S/N 32243N4646BBravo 300 LLC · Coweta, OKS/N 31544N4646CWilliam Michael Moody · Anchorage, AKBuilt 1975 · S/N 18502586N4646HMilton Djana · Lakewood, WABuilt 1981 · S/N 18267847N4646KPloense Justin M · Big Bear City, CAS/N 18263648N4647AAuch Leo R · Scio, ORBuilt 1956 · S/N 32244N4647SJnjz Enterprises LLC · The Woodlands, TXBuilt 1975 · S/N TC-1910N4648ATimms Chet D · Central City, IABuilt 1983 · S/N P21000812N4648ERandall John Kelly · Fremont, OHBuilt 1982 · S/N 18268254
Back to AD 2000-23-21