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.

N342MMJohnson Aaron M · San Ramon, CAS/N 18258570N342MWHolway Stephen M · Gainesville, FLBuilt 1979 · S/N 18267144N342SHorn Travis L · Clarksville, ARBuilt 1969 · S/N E-189N342SRRh Air LLC · Slinger, WIBuilt 2007 · S/N 2342N342TTLewis Charles Ryan · Napa, CABuilt 2004 · S/N 1236N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251N342ZBaus Jordan M · Seattle, WABuilt 1960 · S/N CD-230N3430FWingeier Dairy Farms · Alto, MIBuilt 1966 · S/N 18257430N3430LDachniwsky Holdings LLC · Southlake, TXBuilt 1974 · S/N 18263459N3430SBlue Skai Aviators LLC · Lawton, OKBuilt 1964 · S/N 18255830N3431LJacobs Brittany Lyn · Seattle, WABuilt 1966 · S/N U206-0731N3431RGuibaud Albert G · Monrovia, CABuilt 1967 · S/N 18258731N3431YMinor Joseph H · Hyannis, NEBuilt 1968 · S/N 18051931N3432FBierschwale Land Co LLC · Mason, TXBuilt 1977 · S/N 21062407N3433FVapor-Mist Sanitizing Systems · Boca Raton, FLS/N 18257433N3433QGhamari Seyavosh · Irvine, CAS/N 28R-7703109N3433RAlty It Solutions LLC · Milan, MIBuilt 1967 · S/N 18258733N3433SKah Gretchen Wendel · San Francisco, CABuilt 1964 · S/N 18255833N3434RBurkhardt James · Brookings, SDBuilt 1967 · S/N 18258734N3434SDawsey Carl E · Long Beach, MSBuilt 1964 · S/N 18255834N3434T34t Leasing LLC · Englewood, COBuilt 2013 · S/N 0479N3434UHale William R · Covina, CABuilt 1963 · S/N 18254834N3435FDickens Frank K · Moncure, NCS/N 18257435N3435UJackson Terry W · Lewisburg, TNBuilt 1963 · S/N 18254835N34360Betzoldt Linda M · Tecumseh, MIS/N 203N3436ARegistered aircraftBuilt 1970 · S/N TE-795N34375Pruitt Jamon R · Springdale, ARBuilt 1954 · S/N 218N3437FYankee Air LLC · Valdosta, GAS/N 18257437N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037N3437RSmith Darrin M · Torrance, CABuilt 1968 · S/N 18258737N3437YLanding Gear Works LLC · Renton, WAS/N 18051937N34380Ackerman Kurt · Kingman, AZBuilt 1960 · S/N 262N34383Crestair Air LLC · Dover, DEBuilt 1961 · S/N 265N34386Jopson Charles M · Etna, CABuilt 1961 · S/N 268N34387Schoenborn Robert F · Folsom, CABuilt 1961 · S/N 269N3438RDauenhauer Colby · Springtown, TXBuilt 1967 · S/N 18258738N3438UGrau Gary Wayne Jr · Yelm, WABuilt 1963 · S/N 18254838N34391Harding Nelson · Lebanon, ORS/N 273N34392Harding Nelson · Lebanon, ORBuilt 1962 · S/N 274N34393Registered aircraftBuilt 1962 · S/N 275N3439SProtsman Bryan D · Anchorage, AKBuilt 1964 · S/N 18255839N3439UFlycatcher Aviation LLC · Purcell, OKBuilt 1963 · S/N 18254839N343ABPonderosa 343 LLC · Richmond, VABuilt 2000 · S/N E-3343N343BFThreesup LLC · Herndon, VABuilt 2023 · S/N 9380N343BMRolfe Aviation LLC · Bellevue, WABuilt 2026 · S/N 11220N343BPShelton Joseph H · Fort Worth, TXBuilt 2007 · S/N 2340N343CBHot Tamale Aviation LLC · Blue Ash, OHBuilt 2024 · S/N 9851N343CDMastin Air LLC · Dover, DEFirst renewal noticeBuilt 2005 · S/N 1343N343DBBrown Patrick T Trustee · Osceola, WIBuilt 1957 · S/N BG-317N343HPMonada Air Inc Trustee · Wilmington, DEBuilt 2003 · S/N 3449281
Back to AD 2000-23-21