AD 2001-08-08

Registered aircraft · 5,765

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:2001-08-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-08')
  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.

N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652N13BLCross Country Aviation LLC · Park City, UTBuilt 1975 · S/N E-724N13EJAvidash LLC · Cape Coral, FLS/N CE1130N13RKSwartz Charles Harris Jr · Spicewood, TXBuilt 1978 · S/N E-1238N13VMAhs Aero LLC · Phoenix, AZBuilt 1975 · S/N CE-552N13YZCreative Destination Development LLC · Mount Pleasant, TXBuilt 1976 · S/N E-859N13ZZTigerair Of Alabama Inc · Newark, DEBuilt 1973 · S/N E-464N140NLN140nl LLC · Maumelle, ARBuilt 1966 · S/N CE-27N1417BDavis Brad Michael · Whitesboro, TXBuilt 1967 · S/N D-8550N141HPBrankin Enterprises Inc · Dover, DES/N E-1815N141TWHunt Bradley · Wichita Falls, TXBuilt 1974 · S/N D-9634N141WSCopper Spike Aero LLC · Douglas, WYBuilt 1965 · S/N D-7995N142HGN142hg LLC · Manhasset, NYBuilt 1969 · S/N D-9020N1437AWashington Adrian P · Palm Harbor, FLBuilt 1969 · S/N D-9013N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633N144KPrescott Medical Relief Services LLC · Prescott, AZBuilt 1977 · S/N E-947N144PTHill Howard H Trustee · Portage, WIBuilt 1990 · S/N E-2553N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496N144SBPeters Aircraft Sales Flp · Wshngtn Ct Hs, OHBuilt 1979 · S/N CE-862N144TDDahlberg Thomas K · Belvidere, ILBuilt 1999 · S/N E-3289N1450BBerry Boger Yacht Sales Inc · North Myrtle Beach, SCBuilt 1977 · S/N E-989N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235N146BPNoughton Larry W · Fort Myers, FLBuilt 1994 · S/N CE-1775N147DTGabriella Elena Inc · Winnetka, ILBuilt 1998 · S/N E-3163N147PN147p LLC · Wilkesboro, NCBuilt 1979 · S/N CE-868N147PWBarr Tammy D · Spicewood, TXBuilt 2001 · S/N E-3420N147UMartin Delano R · Spring, TXS/N D-8533N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161N149WLCarter Robert J Jr · Oak Ridge, TNS/N E3562N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298N14FMDurbin Gregory M · Dallas, TXS/N D-7802N14JPDakota Aircraft Inc · Pierre, SDBuilt 1986 · S/N CJ-177N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062N14MNOne Room LLC · Abilene, TXBuilt 1978 · S/N E-1344N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14WWWa Consulting LLC · Nashville, TNS/N E-3297N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768N1500FGerhold Jeremy · Rosharon, TXS/N D-8552
Back to AD 2001-08-08