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.

N880TWEnvisage LLC · Virginia Beach, VABuilt 1969 · S/N TC-1240 N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968 N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969 N8814Eer LLC · Camp Hill, PAS/N TC-1337 N8814CGharazeddine Raja N · Kaplan, LABuilt 1976 · S/N 34-7670155 N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972 N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973 N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975 N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976 N881FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496235 N881RMMadden Robert B · Eagleville, PABuilt 1966 · S/N 310K0114 N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259 N8822ZSmith Roy · Houston, TXBuilt 1980 · S/N 34-8170018 N8823YFerrara John M · Newtown, PABuilt 1969 · S/N 30-1981 N882ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496317 N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470 N882FTFlorida Institute Of Technology · Melbourne, FLS/N 4496248 N882MTGta Air Inc · Addison, TXBuilt 1982 · S/N TH1343 N8833YGagan Samrat LLC · Charlotte, NCBuilt 1969 · S/N 30-1991 N8836YLodge Aviation LLC · Lewes, DEBuilt 1969 · S/N 30-1994 N8837YWilfly Inc · Dahlgren, ILBuilt 1969 · S/N 30-1995 N8838YWaterwings Seaplanes LLC · Hoover, ALBuilt 1969 · S/N 30-1993 N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2 N883ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496320 N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000 N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3 N8845MFodor Vincent A · Doylestown, OHBuilt 1964 · S/N TC-596 N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907 N884ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496321 N884FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 4496250 N884LPBecton Aviation LLC · Lubbock, TXS/N 421C0102 N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239 N88521Godfrey Pharis · Missouri City, TXBuilt 1981 · S/N 340A1260 N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7 N88537Gink2 LLC · Elkhorn, NEBuilt 1978 · S/N 421C0514 N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240 N88549Seed Richard J IV · Holmes Beach, FLBuilt 1981 · S/N 340A1261 N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9 N88555Iverson Douglas B · Sammamish, WABuilt 1981 · S/N 340A1262 N8856KHerrmann Alan J · Laguna Niguel, CABuilt 1981 · S/N 340A1264 N8857KBall Bearing Aviation LLC · Lowell, ARBuilt 1979 · S/N 340A0642 N8857YLewis Leslie S · Glendale, AZBuilt 1970 · S/N 39-12 N88584Dallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0642 N885ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496322 N885FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496225 N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416 N88604Trade Winds Aviation Holdings LLC · Lewes, DEBuilt 1978 · S/N 421C0604 N88606N88606 LLC · Ely, IAS/N 421C0649 N88646Eagle Air LLC · Garden Ridge, TXS/N 421C0630 N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19

Back to AD 2004-25-16 R1