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.

N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421N378JHPtj Associates LLC · La Canada Flt, CABuilt 2022 · S/N 8932N378PHRegistered aircraftBuilt 2022 · S/N 8690N378RX563bt LLC · Fripp Island, SCBuilt 2004 · S/N 1437N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967N378SPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N U20606322N378TCampisi James R · Senoia, GABuilt 1963 · S/N D-7149N378TAFull Time Betty LLC · Friday Harbor, WABuilt 2020 · S/N 2160N378TTJohnson Aviation Inc · Welcome, MDBuilt 2010 · S/N 2074N378WTFeeser Flight Services LLC · Odessa, TXBuilt 2014 · S/N 0882N378ZHamilton Christopher · Dallas, TXS/N CD-266N3791DRoberts James O · Billings, MTBuilt 1957 · S/N 34491N3791UHarway Inc · Rockingham, NCBuilt 1964 · S/N 18255191N3791YSatanta Flying Service Inc · Satanta, KSBuilt 1964 · S/N 21058291N3792GNogle Charles H · Champaign, ILS/N G-770N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418N3793UFly Direct Inc · La Porte, INBuilt 1963 · S/N 18255193N3793YBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1964 · S/N 21058293N3794DDelahousie David L · Apple Valley, CAFirst renewal noticeBuilt 1957 · S/N 34494N3795QGreen Aviation Inc · Manchester, MEBuilt 1967 · S/N TE-328N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N3796DHowerton Pamela S · Bartlesville, OKBuilt 1957 · S/N 34496N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914N3796MRoth Jacques A · San Rafael, CABuilt 1978 · S/N 28R-7803194N3797DGeorge Daniel K · West Union, SCBuilt 1957 · S/N 34497N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415N3797YCockroft Roger · Baltimore, MDBuilt 1964 · S/N 21058297N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416N3798UClapper Wesley J · Spokane, WABuilt 1963 · S/N 18255198N3799GRounds Chris · Waller, TXS/N G-709N3799MWaldron Ronald · Strongsville, OHBuilt 1980 · S/N E-1774N3799PCt Services LLC · Albuquerque, NMBuilt 1978 · S/N P21000055N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433N379CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2005 · S/N 1465N379JTN379jt LLC · Spokane, WABuilt 1978 · S/N 18503629N379SRSweetwater General Contracting LLC · Cumming, GABuilt 2006 · S/N 1928N379SVSahara Viking Aviation LLC · Ocoee, FLBuilt 1979 · S/N 79-30945N379TCherney Cody L · Belleville, KSS/N D-7220N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616N37BAAmbler Robert L · San Diego, CABuilt 2001 · S/N 40020N37BCBarnes David L · Palmer, AKBuilt 1976 · S/N 18502965N37BJDodson Jeffrey C · Monroe, GABuilt 1973 · S/N 33701503N37BRC&D Pharmaceuticals Berry Inc · Berry, ALBuilt 1981 · S/N E-1860N37BSMatthew Davis · Asheville, NCBuilt 1974 · S/N E-548N37CHDehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1460N37CLAlexander Wolf Corp · Reno, NVBuilt 2022 · S/N 8745N37EFProctor John · Rosebud, TXS/N 31006N37EWKundel Andrew R · Muscatine, IAS/N U20602997N37FGState Of California · Sacramento, CABuilt 2008 · S/N 446-33/OB2N37GWillamette Valley Soaring Club · Beaverton, ORBuilt 1966 · S/N 188-0166
Back to AD 2000-23-21