Skip to content

AD 2004-25-16 R1

Registered aircraft · 10,537

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

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:2004-25-16-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1') ORDER BY n_number

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

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:2004-25-16-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N393TBTom Brown Consulting LLC · Ave Maria, FLBuilt 1969 · S/N 30-1874 N39466Xing Kong Aviation Service LLC · Atwater, CABuilt 1978 · S/N 34-7870379 N394SFCity Wings Inc · St Thomas, VIBuilt 2005 · S/N 20800394 N394TAikens George · Greeley, COS/N TC-854 N3951XLucky 20 Gourmet And Adventure Club LLC · Syracuse, INBuilt 1975 · S/N 34-7670003 N39522United States Air Force Elmendorf Aero Club · Elmendorf Afb, AKBuilt 1978 · S/N 34-7870385 N39530Carroll Aaron W · Sarasota, FLBuilt 1978 · S/N 34-7870386 N39592Paratus Air Inc · Auburn, INFirst renewal noticeBuilt 1978 · S/N 34-7870395 N39594J Airco LLC · Nashville, TNBuilt 1978 · S/N 34-7870396 N3959GUniversal Aviation LLC · Decatur, ARS/N 340A0243 N395JJCate Kyle T · Johnstown, COBuilt 1978 · S/N 34-7870393 N395KGBatsche George M Jr · Tampa, FLFirst renewal noticeBuilt 1981 · S/N 348133030 N3960GLubard Stephen C · Woodland Hills, CAS/N 340A0244 N39621Zulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 44-7995016 N3962XPureflight Aviation Training LLC · Newberg, ORS/N 34-7670007 N3963GKohsel Aviation LLC · Holland, MIS/N 340A0246 N39655Weather Modification LLC · Fargo, NDBuilt 1978 · S/N 34-7870403 N39669Lane Community College · Eugene, ORBuilt 1978 · S/N 44-7995021 N3968GWatkins Aviation LLC · Golden Valley, MNBuilt 1977 · S/N 421C0422 N3968XMoorhead Equipment LLC · Belton, SCBuilt 1975 · S/N 34-7670009 N396JHGoode Todd · Nampa, IDS/N 31T-7920087 N39704Sunrise Aviation · Ormond Beach, FLBuilt 1978 · S/N 44-7995026 N39724Huebscher Attila · Pittstown, NJBuilt 1978 · S/N 34-7870418 N3974XAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 34-7670011 N39759Shoaf Thomas P · Alamogordo, NMBuilt 1978 · S/N 34-7870419 N3979JMyers Melissa · Yukon, OKBuilt 1978 · S/N 34-7870346 N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207 N397DFolse Michael John · San Jose, CABuilt 1968 · S/N TC-1109 N3980GGoods Thomas Jr · Romulus, MIS/N 340A0252 N3981GSilver David S · Brookings, ORS/N 340A0253 N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255 N3984Epstein Steven D · Vallejo, CABuilt 1970 · S/N P-147 N398PGeorge Monte C · Ashland, ORBuilt 1966 · S/N 320D0106 N398SPHillcrest Aviation LLC · Clear Lake, IAS/N 31T-8104027 N3995MParsons John J · Winter Park, FLFirst renewal noticeBuilt 1978 · S/N 34-7870143 N399MCRegistered aircraftBuilt 1975 · S/N TC-1852 N399TLWilson Aircraft Inc · Independence, MORegistration revokedBuilt 1969 · S/N P-54 N399TTJuliet Foxtrot LLC · Youngstown, NYBuilt 1986 · S/N 20800099 N39CACannondale Aviation L L C · Wilton, CTS/N 31-8212030 N39CRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 39-4 N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246 N39EAir Agco LLC · Bell City, MOBuilt 1978 · S/N 34-7870160 N39EHAir Travel Management Of Delaware LLC · Wilmington, DEBuilt 1978 · S/N 31T-7920020 N39HASmc Ltd · Somerset, WIS/N 31-497 N39HCTherapy Air LLC · Midland, TXS/N 414-0469 N39HLCoastal Mobility LLC · Wilmington, NCBuilt 1985 · S/N TH-1500 N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943 N39KYYang Chi · Lafayette, COBuilt 1979 · S/N 447995304 N39PMBank Of Utah Trustee · Salt Lake City, UTS/N 34-8233049 N39TLDunamis Resources LLC · Lewes, DES/N 31T-8104012

Back to AD 2004-25-16 R1