AD 2002-25-09

Registered aircraft · 448

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

N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849N1529WOlathe Spray Service Inc · Olathe, COBuilt 1992 · S/N 401-0848N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847N1534DEdge Aviation LLC · Moberly, MOBuilt 1992 · S/N 402A-0855N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171N15439Dietz Timothy E · Wasilla, AKS/N 401-0862N15449Headwaters Flying Service LLC · Three Forks, MTBuilt 1992 · S/N 401-0868N1544RRas Aviation LLC · Elyria, OHBuilt 1992 · S/N 401-0864N1546UBauer Charles A · Graceville, MNBuilt 1992 · S/N 401-0873N1546XHopkins Robert E Jr · Sumter, SCBuilt 1992 · S/N 401-0874N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183N1554KBasin Aviation Inc · Rio Oso, CAS/N 401-0882N1556WPrecissi Flying Service Inc · Lodi, CAFirst renewal noticeBuilt 1992 · S/N 502-0185N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175N1558URba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0188N166MMCrider Flying Service Inc · Swifton, ARBuilt 1999 · S/N 502A-0572N182PBDodson International Parts Inc · Rantoul, KSS/N 402-0806N186DCAir Care Inc · Lamar, COBuilt 1992 · S/N 502-0186N198LAVissair LLC · Rigby, IDBuilt 1993 · S/N 502-0198N2003BBrylen 502 LLC · Dumas, TXBuilt 2011 · S/N 502A-2741N202FHTr Flying Service LLC · Milan, MNBuilt 1992 · S/N 402A-0867N205CGSeewald Jeffrey W · Great Bend, KSBuilt 2006 · S/N 502A-2603N205RMLissie Flying Service Inc · Lissie, TXBuilt 1998 · S/N 502A-0491N2137UNewberg Sky Spray LLC · Hector, MNS/N 301-0423N2254LPhoenix Equipment Lc · Nickerson, KSFirst renewal noticeBuilt 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, KSFirst renewal noticeS/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-0402
Back to AD 2002-25-09