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.

N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N24TEKurtz James F · Bethesda, MDBuilt 1970 · S/N 39-53 N24WEPake Flying Services LLC · Felton, MNBuilt 1998 · S/N 3449071 N24YCBeauchene Air II LLC · Des Moines, IABuilt 1970 · S/N 27-4551 N2501MSchwietz Thomas E Jr · Strasburg, VAS/N 27-7954068 N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045 N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082 N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91 N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148 N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681 N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364 N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070 N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039 N251ASMil2atp Inc · Pikeville, NCBuilt 1980 · S/N 34-8070119 N251ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496047 N251EARegistered aircraftBuilt 1969 · S/N 27-4238 N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311 N2523VExpress Flight LLC · Bloomingdale, GABuilt 1975 · S/N 34-7570143 N2526QRegistration Pending · Lithonia, GARegistration pendingBuilt 1977 · S/N 34-7770189 N2527SCensair LLC · Santa Fe, NMBuilt 1967 · S/N 337-0827 N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984 N252WABettendorf Nicholas L · Mchenry, ILBuilt 1980 · S/N 34-8070211 N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806 N253ATAirlines Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496057 N253DSIpmad Vpmc Aerial Mosquito Control · New Iberia, LABuilt 1980 · S/N 31-8052142 N253TATalon Air Service Inc · Soldotna, AKBuilt 1992 · S/N 20800222 N2545CDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496324 N25460Kleen Sheen IV LLC · Bowling Green, KYBuilt 1985 · S/N 34-8533041 N254ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496062 N254KPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496652 N254PBNicole Business Group LLC · Hooks, TXBuilt 1982 · S/N 340A1504 N254TM56h LLC · St Simons Island, GABuilt 1979 · S/N 414A0254 N254WTClik Services LLC · Forestdale, MABuilt 1968 · S/N 337-0921 N2554SHanan Roy T · Edgewater, FLS/N 337-0854 N2556RRed Willow Rescue Inc · Cooperstown, NDBuilt 1979 · S/N 31T-8004003 N255EM255em LLC · Tampa, FLBuilt 1973 · S/N TC-1552 N255FSSharpline Converting Inc · Wichita, KSBuilt 1980 · S/N TC-2306 N255MBPhoenix Aircraft Management LLC · Marathon, FLFirst renewal noticeBuilt 1968 · S/N 310N-0110 N255RWas Group LLC · Wilmington, DEBuilt 1973 · S/N TC-1518 N255TJVolar II LLC · Edmond, OKBuilt 2016 · S/N 4496394 N255WPUnited States Air Force Owner · Hanscom Afb, MAFirst renewal noticeS/N TF-38 N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295 N2562MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954078 N25631Myers Robert G · Monument, COBuilt 1973 · S/N TC-1523 N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301 N25659Greenery LLC · Wilmington, DEBuilt 1973 · S/N TC-1596 N25676Ciabattoni David E · Wallingford, PABuilt 1973 · S/N TC-1597 N2568MDe La Cruz Ronaldo · Cape Coral, FLBuilt 1979 · S/N 27-7954079

Back to AD 2004-25-16 R1