OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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.

N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073N200RTRiley Nolan C · Lubbock, TXS/N TK-101N200SBSoaring Hawk Aviation LLC · Dexter, MIBuilt 1978 · S/N 34-7870399N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601N200SPN200sp LLC · Erie, COBuilt 1967 · S/N TE-487N200TWeishaar Walt E · Livingston, TXBuilt 1964 · S/N 15060991N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921N200UGRaw Logistics LLC · Bethel, NCBuilt 1978 · S/N E-1225N200VPDrp Aviation LLC · Southlake, TXBuilt 2000 · S/N 29-0231N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478N200WWRoark LLC · Bend, ORBuilt 1985 · S/N 46-8508035N2010GFox Stephen A · Wasilla, AKBuilt 1958 · S/N 51310N2010WHogsett Troy J · Willow Springs, MOBuilt 1965 · S/N CD-972N2010XHutchinson Darrold K Trustee · Hingham, MTBuilt 1965 · S/N 18256110N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979N2011TEfferson Randal K · Lapine, ALBuilt 2016 · S/N 29-0524N2011XSalem Ricky L · Burnet, TXBuilt 1965 · S/N 18256111N2012GMchugh Michael J Trustee · Hailey, IDBuilt 1958 · S/N 51312N2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMBuilt 1964 · S/N 18255212N2012S9791m LLC · Tacoma, WAS/N 21060980N2012WIron Compass LLC · Highland Park, MIBuilt 1965 · S/N D-7971N2013RZinsmeyer Charles D · Llano, TXBuilt 1964 · S/N 18255213N2013UBenedict Michael T · Anchorage, AKS/N 1066CN2013XEec Group LLC · Kalispell, MTBuilt 1965 · S/N 18256113N2014Blue Skies Trading Company LLC · Toledo, OHS/N 18052338N20148Baron 1-4-8 LLC · Merrimack, NHS/N TC-2159N2014RDaedalus Wings Inc · Malvern, OHBuilt 1964 · S/N 18255214N2014XTashjian Kirk G · Stanwood, WABuilt 1965 · S/N 18256114N2015CMorgan Arrow LLC · Greeley, COBuilt 1978 · S/N E-1311N2015RBennett Peter D · Birmingham, ALBuilt 1964 · S/N 18255215N2015T2015t LLC · Omaha, NEBuilt 1978 · S/N CE-795N2015VMangi Nitin · Hayward, CABuilt 1959 · S/N D-5760N2015WKrosswind Aviation LLC · Cape Coral, FLBuilt 1965 · S/N D-7975N2015XAircraft Trade Group LLC · Scandia, MNS/N 18256115N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004N2016CRavey Guy W · Virginia Beach, VABuilt 1978 · S/N TC-2175N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209N2016KAlp Paul · Falls Church, VABuilt 1978 · S/N TC-2163N2016NOsfly LLC · Wilmington, DEBuilt 1978 · S/N E-1313N2016RCoburn William L · Snohomish, WAS/N 18255216N2016XSmith James A · Lyle, WAS/N 18256116N2016Y2016y LLC · Aurora, COBuilt 1978 · S/N D-10157N2017GZolezzi Paul A · Cottage Grove, ORS/N 51317N2017PBruninga Harold J · Jacksonville, ILBuilt 1978 · S/N D-10156N2017WDucharme Paul Quin · Lafayette, LABuilt 1965 · S/N TE-12N2017XJensen Timothy L · Hudson, WIBuilt 1965 · S/N 18256117N2018ADiamond B Farms Trucking Inc · Gamaliel, KYBuilt 1978 · S/N E-1321N2018CChandelle Ltd · Brighton, COBuilt 1960 · S/N D-6498N2018GWalsh Linda L · Anchorage, AKBuilt 1958 · S/N 51318
Back to AD 2000-23-21