OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,135

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.

N109FTCisco Aero LLC · Cisco, TXBuilt 2006 · S/N 2025N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921N109KBWings Aviation Inc · Valparaiso, INBuilt 1978 · S/N 28R7803043N109LLLewis & Lewis Equipment LLC · Dodge City, KSBuilt 1991 · S/N E-2626N109MLJerry Luttrell And Associates Inc · Kearney, MOBuilt 1988 · S/N E-2450N109QShariff Diane · Cameron Park, CABuilt 1966 · S/N D-8126N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616N109RFBartley Scott C · Chaska, MNBuilt 1984 · S/N 25-0819N109SWChugiak Aviation Leasing LLC · Chugiak, AKBuilt 1977 · S/N U20603799N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160N109WESpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 347870405N109WKEast Bay Trading Co · Fairview, PABuilt 2004 · S/N 1400N109WYPerala Daniel R · Cheyenne, WYBuilt 1969 · S/N 18260131N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046N10ACNext Flight LLC · Nokomis, FLBuilt 2022 · S/N 8782N10AKCygnus Holdings LLC · Ballwin, MOBuilt 1969 · S/N TE-765N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738N10BManasota Aviation LLC · Saint Petersburg, FLBuilt 2022 · S/N 8963N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539N10BNBlack Thomas D DBA · Clearwater, FLBuilt 1975 · S/N 34-7570050N10BPPeyton James L II · Granby, COBuilt 1973 · S/N D-9533N10BSB R S Leasing Inc · Wilmington, DEBuilt 1971 · S/N TE-841N10BVZondlo Todd · Phoenix, AZBuilt 1972 · S/N D-9345N10BXCleary James A · Fairfield Township, OHBuilt 2021 · S/N 5003N10CABrunson Richard P · New Braunfels, TXBuilt 2007 · S/N E-3814N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10CDAvbase Flight Group Inc Trustee · Wilmington, DEBuilt 2012 · S/N 0350N10CNJones Carey N · Chesapeake, VABuilt 2015 · S/N 3RX060N10DBBrandon Donald A Trustee · El Monte, CABuilt 1977 · S/N 21062016N10DCHbk LLC · Lynden, WAS/N U206-05366N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044N10EEBucci Dennis · Pittsburgh, PABuilt 1971 · S/N D-9307N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796N10FLRandall P Roumillat · Dallas, TXS/N 21062892N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646N10HMAggst LLC · Shingle Springs, CABuilt 1978 · S/N 21062908N10HQAndjul Aviation LLC · Palm Beach, FLBuilt 2024 · S/N 10243N10JFRempert Erich A · Lake Geneva, WIS/N NAV-4-1391N10JHHayden Charles J Jr · Richmond, TXBuilt 1973 · S/N 001N10JVHale Thomas O · Cotuit, MABuilt 1973 · S/N 18502242N10KKMensch Air LLC · Miami, FLBuilt 2022 · S/N 8975N10KMJohnson Walter N · Hico, TXS/N 310I0101N10KYMckinnon Laughlin Neil Trustee · Carlsbad, CABuilt 1971 · S/N 18501898N10LFive States Holdings LLC · Helena, MTBuilt 1972 · S/N E-347N10LJHarris Michael V · Wildwood, MOBuilt 1982 · S/N EA-276N10MCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1084
Back to AD 2000-23-21