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.

N3549VSmith Jacques F · Anchorage, AKS/N R1722257N3549YTimuuu Inc · Alden, NYBuilt 1962 · S/N 18254449N354ALErlandsen Alan · Bremerton, WABuilt 1960 · S/N D-6570N354BCChamberlain Donald H · Ooltewah, TNBuilt 1989 · S/N E-2485N354BWCarpenter Richard A · Hermiston, ORBuilt 1979 · S/N EA-40N354DAir Repair Inc · Deadwood, SDBuilt 1964 · S/N D-7659N354DGGaines Lawrence C · Stockton, CABuilt 1958 · S/N D-5573N354DJN354dj LLC · Gulfport, MSBuilt 1980 · S/N D-10326N354DPShaffer John · Virginia Beach, VABuilt 1966 · S/N D-8309N354DRRadwanski D · Westmont, ILBuilt 1978 · S/N D-10102N354DZDachnowicz Peter A · Avon, CTBuilt 1972 · S/N D-9336N354EMSrm Aviation Solutions LLC · Richland, WABuilt 2007 · S/N 2634N354FBCleared Direct LLC · Portland, ORBuilt 1962 · S/N D-6961N354FCBlue Sky November LLC · Mamaroneck, NYBuilt 2020 · S/N 4875N354JMountain V-Tail LLC · Denver, COS/N D-7857N354KPTri County Flying Club Llp · Estelline, SDBuilt 1964 · S/N D-7612N354LCDelos Anesthesia Services Pc · Barstow, CABuilt 1966 · S/N D-8161N354MMission Aviation LLC · Billings, MTBuilt 1964 · S/N D-7516N354PFBillen Jerome · Hodges, SCBuilt 1972 · S/N D-9313N354SNKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2016 · S/N 1354N354XBeaver Creek Aviation LLC · Clinton, OKS/N 24512N355Roads Development LLC · Miami, FLS/N P3370239N3550FYoung Tom · Alton, MOBuilt 1966 · S/N 18257550N3550UYoung Mary J D · Waynesville, OHBuilt 1963 · S/N 18254950N3550YForman Barnes LLC · Nampa, IDBuilt 1962 · S/N 18254450N3551FBursley Richard R · Phoenix, AZBuilt 1966 · S/N 18257551N3551UFallini Anna M · Tonopah, NVBuilt 1963 · S/N 18254951N3551YWethered Dvm LLC · Boise, IDBuilt 1962 · S/N 18254451N3552FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18257552N3553YMiller Jaime W · Deer Park, NYS/N 18254453N3555FStern Andrew · New York, NYBuilt 1966 · S/N 18257555N3556HRocket Joy LLC · Aurora, COBuilt 1980 · S/N 25-0421N3556YLodestar Aviation LLC · Mooresville, NCBuilt 1962 · S/N 18254456N3558FPacific Rim Adventures Inc · Los Olivos, CAS/N 185-1438N3558HPearce Terrace Edwin · Theodosia, MOBuilt 1980 · S/N 25-0422N3558YRegistered aircraftS/N 18254458N355ADSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N TC-2409N355AJTexas Flyers LLC · Amarillo, TXBuilt 1978 · S/N 28R-7803282N355DCRyan John T · Salina, KSBuilt 1984 · S/N 46-8408079N355DJVerdoljak Corey A · Homer, AKBuilt 1977 · S/N 18502954N355GKAircraft Holding And Leasing LLC · Sarasota, FLBuilt 2019 · S/N 4799N355GRGilson Steve · Covington, LABuilt 1957 · S/N D-5328N355LTLt Group Holdings LLC · Newark, DEBuilt 2022 · S/N 8991N355MJHaldeman Richard C · Frisco, TXBuilt 2010 · S/N 3550N355MWCotton Aviation Enterprises Inc · Lakeway, TXBuilt 2007 · S/N 2554N355NEMeyers Air Service LLC · Superior, NEBuilt 2012 · S/N 3902N355PTasaair LLC · Wellington, FLBuilt 1979 · S/N TC-2273N355PGLips78 LLC · Windermere, FLBuilt 2017 · S/N 1499N355SAReddy James N Trustee · Port Orange, FLBuilt 2000 · S/N E-3357N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795
Back to AD 2000-23-21