OpenAirDocs.org
AD 2003-06-01

Registered aircraft · 135

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

N105DAKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1986 · S/N 3010653N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640N2137UNewberg Sky Spray LLC · Hector, MNS/N 301-0423N2254LPhoenix Equipment Lc · Nickerson, KSBuilt 1985 · S/N 400-0611N23069Ag Spray Inc · Moorhead, MNBuilt 1981 · S/N 301-0350N2306ABlanke Jason F · Mandeville, LABuilt 1981 · S/N 400-0345N23095Bellamy Mark A · Freeville, NYBuilt 1981 · S/N 301-0356N2314QPitt And Pitt Aviation · Wapato, WABuilt 1981 · S/N 301-0360N2317ZCarlson Tatum D · Lake Bronson, MNBuilt 1981 · S/N 301-0364N23219Thiel Air Care Inc · Chowchilla, CAS/N 301-0369N23257Phoenix Equipment Lc · Nickerson, KSS/N 301-0371N23260Snake River Aviation LLC · Pomeroy, WABuilt 1981 · S/N 301-0373N23313Thomas Ag Aerial Inc · Thomas, OKBuilt 1981 · S/N 301-0376N23416Woodley Aerial Leasing LLC · Walnut, ILBuilt 1981 · S/N 301-0385N2347PDakota Air Spray LLC · Huron, SDBuilt 1981 · S/N 301-0388N23600Hayton James B · Sedro Woolley, WAS/N 301-0398N23616Putz Gary D · Hearne, TXBuilt 1981 · S/N 301-0400N23618Aerinova Aerial LLC · Mattoon, ILBuilt 1981 · S/N 400-0402N23647Marlow Aviation LLC · Lamoni, IABuilt 1981 · S/N 301-0407N23649Abernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 400-0408N2367CThiel Air Care Inc · Chowchilla, CAS/N 301-0412N23744Van Horne Robert E · Centralia, ILBuilt 1982 · S/N 400A-0429N2374WThomas Ag Aerial Inc · Thomas, OKBuilt 1982 · S/N 301-0428N2378QMcguires Flying Service LLC · Obion, TNBuilt 1982 · S/N 301-0454N23810Wenzel Richard E · Garretson, SDBuilt 1982 · S/N 301-0431N23813Davis Blake A · Bellevue, TXBuilt 1982 · S/N 400A-0433N2386WWhitten Flying Service Equipment LLC · Snook, TXS/N 301-0437N2393NMid Mo Ag Air LLC · Boonville, MOS/N 400-0441N2394NAssociated Aerial Applicators Inc · La Salle, COBuilt 1982 · S/N 400A-0446N23951Rowland Dusters LLC · Raymondville, TXS/N 400A-0447N301DKPetersen Dakota D · Kenmare, NDS/N 3010644N301GLKroeplin Air LLC · Highmore, SDBuilt 1985 · S/N 301-0595N301WDCarlson Production Services LLC · Norcross, MNBuilt 1978 · S/N 301-0143N3157BMarlow Aviation LLC · Lamoni, IAS/N 400A-0449N3157CTronstad Jorn · Sunnyside, WABuilt 1982 · S/N 301-0451N3158ZThompson Frank L · Weiser, IDS/N 301-0457N3159MRed Rdd LLC · Powell Butte, ORBuilt 1982 · S/N 301-0468N3159PJarrett Airspray Inc · Jamestown, NDBuilt 1983 · S/N 301-0486N3160QAg Cat Applicators LLC · Avoca, TXBuilt 1982 · S/N 400-0477N3160TCurless Harley J · Havana, ILBuilt 1983 · S/N 301-0478N3160XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1983 · S/N 301-0479N31623Pitt & Pitt Inc · Wapato, WABuilt 1983 · S/N 301-0522N31626James Richard W · Chowchilla, CABuilt 1983 · S/N 400-0511N3164BL & L Flying Inc · Glen Allan, MSBuilt 1984 · S/N 400-0513N3165ASchnoor Ag & Air LLC · Cambridge, MDBuilt 1984 · S/N 301-0544N3165COmstead Jordan J · Lamoni, IABuilt 1984 · S/N 301-0545N3166YDixie Crop Care Inc · Dixie, GABuilt 1984 · S/N 400-0515N31676Associated Aerial Applicators · Lasalle, COBuilt 1984 · S/N 301-0560N3167PMarlow Aviation LLC · Lamoni, IABuilt 1984 · S/N 301-0553N3167TUltra Ag Cropdusters LLC · Le Mars, IABuilt 1984 · S/N 301-0554
Back to AD 2003-06-01