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.

N38282Zemetis Terence A · Meriden, CTBuilt 1981 · S/N E-1819N3828DWarner Thomas E · Beloit, OHBuilt 1957 · S/N 34528N3828NSallustio Eric · Lake Butler, FLBuilt 1981 · S/N E-1818N3828UNorthern Ventures Aviation LLC · Wasilla, AKBuilt 1964 · S/N 336-0128N3828XAmerican Flightscope Inc · Wilmington, DEBuilt 1981 · S/N TC-2374N3828YHall Edmond · Bremerton, WABuilt 1964 · S/N 21058328N3829PRalphs Thomas A · Solana Beach, CABuilt 1978 · S/N P21000062N382CBMoncada Ramos Edwin Antonio · Lawrenceburg, KYBuilt 1974 · S/N 75-30731N382CDLakeview Aviation LLC · Middletown, DEBuilt 2005 · S/N 1390N382CPScenic Route LLC · Fargo, NDBuilt 2007 · S/N 1871N382CRSkyport Aviation LLC · Oxford, MIBuilt 1982 · S/N T30300096N382CSElrod Aviation LLC · Swanton, OHBuilt 2015 · S/N T24002082N382DEMpt LLC · Tulsa, OKBuilt 2019 · S/N 4810N382DJTimm David M · Napa, CABuilt 2009 · S/N 3450N382GCLacomette Ted W · Tijeras, NMBuilt 1957 · S/N 34195N382MGMissionary Air Group Inc · Burlington, NCBuilt 1979 · S/N U20605256N382SHernandez Luis A · Longview, TXBuilt 1966 · S/N TE-166N382SMJones Darrel E · Sonoma, CABuilt 1964 · S/N 18255714N382SRJernigan Raymond James · Scotts Valley, CABuilt 2006 · S/N 2133N382TTWill Rittner · Sevierville, TNS/N G-143N3830DDouble J Mining LLC · Palmer, AKBuilt 1957 · S/N 34530N3830GAerial Transport LLC · Dover, DES/N U206-0830N3830YRice Kevin L · Pleasant View, COBuilt 1964 · S/N 21058330N3831GPanepinto Lane L · Lafitte, LAS/N U206-0831N3832DKim Sungtae · Fort Worth, TXS/N 34532N3832YMtfg LLC · Hayden, IDS/N 21058332N3833DEnt Flight Services · Las Vegas, NVBuilt 1957 · S/N 34533N3833TN413zm LLC · Terre Haute, INBuilt 2008 · S/N 31-0108N3834DMilan Ruth A · Edmonds, WABuilt 1957 · S/N 34534N3834ZImmen David F · Bonanza, ORBuilt 1978 · S/N 34-7870225N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671N3835UVan Way Sullivan R · Carencro, LAS/N 336-0135N3835YCarlton Jeffery G · Great Falls, MTS/N 21058335N3837DCameron Russell A · Fort Benton, MTBuilt 1957 · S/N 34537N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395N3837YRounds Chris · Waller, TXBuilt 1964 · S/N 21058337N38385Wahl Michael John · Jefferson, IABuilt 1977 · S/N 28R-7703211N3838GGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1967 · S/N U206-0838N3838XHolzman Douglas S · Hood River, ORBuilt 1966 · S/N 310K0238N3839DHot Rod Aviation LLC · Fayetteville, ARS/N 34539N3839RChad Gunter Enterprises LLC · Albany, GABuilt 1981 · S/N EA-199N3839SBailey Glenn K · Englewood, COBuilt 1981 · S/N EA-210N3839UFrankies Aerial Application LLC · Nampa, IDBuilt 1963 · S/N 336-0139N3839XMigliaccio Vicki Trustee · Idabel, OKBuilt 1966 · S/N 310K0239N383APNavion Cca LLC · Marina Del Rey, CABuilt 2018 · S/N 1829N383BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2010 · S/N 3665N383CDAmsam Transport LLC · Mustang, OKBuilt 2018 · S/N 4619N383CPVanclef Financial Group Inc · San Luis Obispo, CABuilt 2008 · S/N 3067N383CSCantrell Nickie Heath · Blackshear, GABuilt 2016 · S/N T24002100N383JMRegistered aircraftBuilt 2007 · S/N 2632
Back to AD 2000-23-21