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.

N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372N1807NDouble Barrel Aviation LLC · Fort Valley, GABuilt 1981 · S/N TH-1263N1810XAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH1266N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271N1827LCone James R Jr · Lubbock, TXS/N TH-741N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855N18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeBuilt 1977 · S/N TH-814N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936N1MFWise Christopher J · Plano, TXS/N TH-835N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950N2023CFulps Aviation LLC · Winston Salem, NCBuilt 1979 · S/N TH-1012N2026WGta Air Inc · Addison, TXBuilt 1978 · S/N TH-976N2027DNichols Neil A · Aalachicola, FLBuilt 1978 · S/N TH-974N2027UJpb Diversified LLC · Auburndale, FLBuilt 1978 · S/N TH-964N20292Laflight LLC · Goldsboro, NCBuilt 1978 · S/N TH-966N202PSc Infinities LLC · Dover, DEBuilt 1998 · S/N TH-1875N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983N204GAirmart Inc · Lexington, KYS/N TH-2042N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286N2063GHolman Allen S · Knoxville, TNBuilt 1979 · S/N TH-1002N2064VGta Air Inc · Addison, TXBuilt 1979 · S/N TH-1004N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677
Back to AD 2000-22-18