AD 2000-22-18

Registered aircraft · 914

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-22-18')
    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-22-18')
  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.

N3622TShaw Aviation LLC · Greenleaf, IDBuilt 1974 · S/N TH-479N362DLBee Line LLC · Millwood, GABuilt 1992 · S/N TH-1653N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145N3694LRegistered aircraftBuilt 1980 · S/N TH-1176N3695NWalton Jerry Prince Jr · Monticello, FLBuilt 1980 · S/N TH-1192N36AVCook Greg R · Willis, TXBuilt 1992 · S/N TH-1657N36CTExecutive Mission LLC · Round Rock, TXBuilt 1990 · S/N TH-1579N36TAN36ta LLC · Dover, DES/N TH-2056N3701DN3701d LLC · Wilmington, NCBuilt 1980 · S/N TH-1187N3707TFisher Kurt A · San Luis Obispo, CABuilt 1970 · S/N TH-110N3711YAero Venture Lc · Shreveport, LABuilt 1977 · S/N TH-828N3715BNova Jets USA Corp · Orlando, FLBuilt 1980 · S/N TH-1200N3739BD & G Properties Troy LLC · Troy, ALBuilt 1980 · S/N TH-1198N38020Pardue Hines Aviation LLC · Lincolnton, NCBuilt 1980 · S/N TH-1208N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381N3806XTessec LLC · Cincinnati, OHBuilt 1980 · S/N TH-1215N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218N3809KGeneral Aviation Services LLC · Franklin, TNBuilt 1981 · S/N TH-1219N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395N3867GW & S Aviation LLC · Fountain Inn, SCBuilt 1981 · S/N TH-1251N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256N38CEBrad Keener Dds Pa · Harrison, ARBuilt 1971 · S/N TH-116N38DZWoolard Flying Service Inc · Corning, ARBuilt 1990 · S/N TH-1577N38TLBonanza 1 LLC · Hernando, MSBuilt 1991 · S/N TH1642N393FBRegistered aircraftBuilt 2002 · S/N TH-2026N39HLCoastal Mobility LLC · Wilmington, NCBuilt 1985 · S/N TH-1500N3MUAero Equities LLC · Ventura, CAS/N TH-1864N3PEJabr Aviation LLC · Milford, IABuilt 1977 · S/N TH-820N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641N403PAFergany Amr Farouk · Sebastian, FLBuilt 1980 · S/N TH-1182N406PASale Reported · Rantoul, KSSale reported, canceledBuilt 1982 · S/N TH-1338N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593N40JBElk River Aero LLC · Noel, MOS/N TH-338N4108GKimberk Frederick S · Cambridge, MABuilt 1971 · S/N TH-166N4108SBto Aviation LLC · Eden Prairie, MNBuilt 1975 · S/N TH-605N4115SDanielson Adam M · Chassell, MIS/N TH-644N4124WGeaux Automotive Advertising LLC · La Place, LABuilt 2000 · S/N TH-1943N412DPickens Ray T · Pleasanton, TXBuilt 1974 · S/N TH-464N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612N414SWRmi Air LLC · Ocilla, GABuilt 1977 · S/N TH-797N415LWWest Thomas Lee · Payson, AZBuilt 1984 · S/N TH-1417
Back to AD 2000-22-18