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.

N227GEAero Mobil Inc · Wilmington, DEBuilt 2022 · S/N 8595N227GWMercatoair LLC · Newark, DEBuilt 2026 · S/N 11132N227HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 3438N227HWFirst Avenue Aviation LLC · Mountain Brk, ALBuilt 2022 · S/N 8892N227JHRgs Aviation LLC · Lexington, KYBuilt 2015 · S/N 4237N227KCSeven Kilo Charlie LLC · Lawrence, KSBuilt 2021 · S/N 5012N227LPLetourneau Plastics Inc · Oconto, WIBuilt 2015 · S/N E-4072N227MMThf Aviation II LLC · Naples, FLBuilt 2023 · S/N 9326N227MPGo Raleigh Aviation LLC · Cary, NCBuilt 2014 · S/N 4141N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682N227MXValiair Limited Co Trustee · Casper, WYBuilt 2024 · S/N 9954N227PGDiederich Drone Service LLC · Fargo, NDBuilt 2010 · S/N 3675N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523N227RTBarnard David W · La Follette, TNBuilt 2007 · S/N 2357N227SMIpme Management Corp · Jefferson, GABuilt 2004 · S/N 41011N227SPIowa State Patrol · Des Moines, IABuilt 2021 · S/N 5050N227SSRiver Front Akn LLC · Anchorage, AKBuilt 1970 · S/N U20601516N227WBSlamo LLC · Bulverde, TXBuilt 2017 · S/N 4523N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344N2280RRusso John · Seaside, CAS/N T210-0430N2281Guzman Javier A · Sammamish, WABuilt 1979 · S/N R1723129N2281FClassic Air Aviation LLC · Mesa, AZBuilt 1967 · S/N 310L-0081N2281GBurriss James E Jr · Piedmont, SCBuilt 1958 · S/N 51581N2282FSjoblom Donald W · Maple Grove, MNBuilt 1967 · S/N 310L-0082N2283LMoser Jerald L · Tucson, AZS/N D-9948N2284CS L G Enterprises · Shelby Township, MIBuilt 1953 · S/N 30584N2284LUpchurch David E · Bahama, NCBuilt 1976 · S/N E-929N2284MGulf Coast Air LLC · Lakeland, FLBuilt 1977 · S/N 34-7870077N2285CIturriria John M · Kuna, IDBuilt 1953 · S/N 30585N2285GRensberger Scott C · Lake Jackson, TXBuilt 1958 · S/N 51585N2285LN2285l Aviation LLC · Robbinsville, NJBuilt 1976 · S/N E-930N2285MBowman Field Aviation Club Inc · Louisville, KYBuilt 1977 · S/N 34-7870078N2286LBaty John W · Ames, IABuilt 1976 · S/N CE-675N2286QRinker John W · Pontiac, ILBuilt 1977 · S/N 28R-7703062N2287GLockwood William E · Carmel, NYS/N 51587N2288DTen Equipment LLC · Boston, MABuilt 2011 · S/N 3761N2288GSkydive Buckeye LLC · Buckeye, AZBuilt 1958 · S/N 51588N2289BHollister Jet Center Inc · Hollister, CAS/N CE-178N2289ERegistered aircraftBuilt 1997 · S/N TH-1821N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949N228ABLuke Stephen J Trustee · Middleboro, MABuilt 1991 · S/N E-2655N228CCutter Southwest Aircraft Sales LLC · Phoenix, AZBuilt 1985 · S/N CE-1059N228CENamrac Aviation LLC · Hazard, KYBuilt 2014 · S/N TH-2407N228CFAsterix Aviation Inc · New York, NYBuilt 2021 · S/N 5007N228CPColumbia Pacific Aviation Inc · Moses Lake, WABuilt 1978 · S/N 18266514N228DFKv Wines Inc · Calistoga, CABuilt 2012 · S/N 0282N228DLW3 Aviation LLC · Decatur, TXBuilt 2023 · S/N 9042N228DMStone Michael · Payson, AZBuilt 1991 · S/N E-2660N228DWSalty Bleuwater Fishing LLC · New Smyrna Beach, FLBuilt 2019 · S/N 2027N228EEYankee Alpha LLC · Columbia, MDBuilt 2019 · S/N 1979
Back to AD 2000-23-21