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.

N181MCTf1 LLC · Pittsford, NYBuilt 2018 · S/N 4720N181MKHarlow Builders Inc · Troy, OHBuilt 2015 · S/N 1105N181NWitt Robert A · Anchorage, AKBuilt 1956 · S/N 32416N181PJPeake Herschel S · Dallas, TXBuilt 1976 · S/N D-9876N181RBBeltz Richard R · Lehighton, PABuilt 1956 · S/N 32712N181RCWheeler Douglas N Trustee · Santa Fe, NMBuilt 1978 · S/N 18052982N181RDWoodcock Air LLC · Wilmington, DES/N 33701881N181RMHennessee Timothy · New Braunfels, TXBuilt 1961 · S/N D-6666N181RPCain Jeffrey B · Godley, TXBuilt 1981 · S/N 18053180N181SPIkway Air LLC · St Charles, ILBuilt 2023 · S/N 9121N181STWagontrainer LLC · Kalispell, MTBuilt 1954 · S/N 30997N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408N181UKauffman Daniel C · Spring Grove, PABuilt 1981 · S/N 18268135N181WRunway Group LLC · Bentonville, ARBuilt 2013 · S/N 0675N181WTMeadows Robert K · Macon, GABuilt 2003 · S/N 0638N1820FHamilton Aviation LLC · Waycross, GABuilt 1981 · S/N E-1893N1820KBergstrom Aircraft Inc · Pasco, WABuilt 1975 · S/N 182-64092N1820LSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-843N1820RBarkhimer James C · Iraan, TXBuilt 1974 · S/N 18502535N1820ZStaats Douglas E · Anchorage, AKBuilt 1962 · S/N 205-0020N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581N1821FAlexander Travis · Hudson Oaks, TXS/N 21058721N1821RHoward Todd R · Minneapolis, MNBuilt 1974 · S/N 18502536N1821SBailey Ralph E · Sikeston, MOBuilt 1962 · S/N 2050021N1821WModern & Classic Aviation LLC · North Royalton, OHBuilt 1973 · S/N TC-1522N1821XCluer Brian L · Bodega, CABuilt 1964 · S/N 18255921N1822CBrouwer Aviation LLC · Kalamazoo, MIBuilt 1974 · S/N 18262981N1822FFoxtrot Tango Aviaiton LLC · West Palm Beach, FLBuilt 2024 · S/N 10270N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377N1822ROney Tony K · Anchorage, AKBuilt 1974 · S/N 18502537N1822SSnider Nancy J · Washington, DCBuilt 1981 · S/N TC-2357N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424N1822ZAhrens Kevin Michael · Cashmere, WABuilt 1962 · S/N 205-0022N1823AKearns Adam · Portland, ORBuilt 1972 · S/N 18260858N1823RJones Alfred J · Friendsville, PABuilt 1974 · S/N 18502538N1823WMuhler Wayne · Brighton, COS/N TC-1509N1823XN1823x LLC · Middletown, DEBuilt 1964 · S/N 18255923N1824Luvara Michael S · San Jose, CABuilt 1970 · S/N 18260285N18246Radial-Air Leasing Inc · Caro, MIBuilt 1977 · S/N CE-720N1824AVesper David G · Ashland, OHBuilt 1970 · S/N 18260221N1824GHarkness Michael D · San Luis Obispo, CABuilt 1977 · S/N 18265819N1824MHeinke Nils A · Elkins, WVBuilt 1971 · S/N 33701424N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N18255Registration Pending · Los Olivos, CARegistration pendingS/N G-739N18256Registered aircraftBuilt 1956 · S/N 33605N1825CPellar Gregory T · Bigfork, MTBuilt 1953 · S/N 23446N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877N1825QCree William H III · Long Beach, CABuilt 1977 · S/N 18503492N1825RKincaid James B · Wasilla, AKBuilt 1974 · S/N 18502540N1825SEngebretson Christopher D · Greenville, INS/N E-1898
Back to AD 2000-23-21