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.

N8502VAngel Aviation Inc · Peoria, AZBuilt 1973 · S/N 34-7350252 N8503YRoberti John O · Barre, VTBuilt 1967 · S/N 30-1662 N8505YCli Aerospace LLC · Appleton, WIBuilt 1968 · S/N 30-1665 N8506YWilliams Russell D · Rehoboth Beach, DEBuilt 1967 · S/N 30-1666 N8507YWhiteley Robert L · Pittsburg, CABuilt 1967 · S/N 30-1667 N850ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496568 N850CMN850cm LLC · San Luis Obispo, CABuilt 1972 · S/N P-213 N850KFInternational Air Services Inc Trustee · Carson City, NVS/N 310Q-0041 N850PIftikhar Naveed · Tempe, AZBuilt 1979 · S/N 34-7970422 N850RMDueck Arthur P · Lakewood, OHBuilt 1977 · S/N 421C0283 N8510FSkyline Utilities Inc · Brainerd, MNBuilt 1976 · S/N 34-7770089 N8512YSager Garrett · Fort Worth, TXBuilt 1967 · S/N 30-1672 N8513YCrane Douglas Gordon · Coquille, ORBuilt 1967 · S/N 30-1673 N8514CSpirit Air Inc · Salmon, IDBuilt 1976 · S/N 34-7670147 N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675 N8515YPiper Aviation Museum Foundation · Lock Haven, PABuilt 1967 · S/N 30-1676 N8516GTri-State Management Corp · Thomasville, GABuilt 1979 · S/N 340A0702 N851ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496569 N851NDSkymates Inc · Wilmington, DEBuilt 1989 · S/N 4495005 N851PAFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1957 · S/N 23-851 N8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1684 N8526YCarlile John D · The Villages, FLBuilt 1968 · S/N 30-1687 N8527YHatbright Farm LLC · Wilmington, DEBuilt 1968 · S/N 30-1688 N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689 N852ATWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250258 N852NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 4495006 N852TSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 414-0804 N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691 N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696 N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606 N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626 N853MTK & T Inc · Salt Lake City, UTS/N 421C0602 N8540MMcdaniel David S · Madill, OKBuilt 1963 · S/N TC-510 N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568 N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598 N8547FPage Elton T III · Cotulla, TXBuilt 1976 · S/N 34-7770090 N854CBeasley Timber Co Inc · Hazlehurst, GABuilt 2001 · S/N TH-2018 N854NDAero Equities LLC · Ventura, CABuilt 1989 · S/N 4495008 N8555Bank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 44-8207002 N8555YScharf Mark T · Rosamond, CAFirst renewal noticeBuilt 1968 · S/N 30-1702 N8557RC & G Enterprises LLC · Chesterfield, VABuilt 1974 · S/N TC-1768 N8558CDan & Jerrys Greenhouse LLC · Monticello, MNBuilt 1976 · S/N 34-7670148 N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705 N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174 N855CZimmerman Walker D · Nashville, TNS/N TC-796 N855HSanford Larry D · Edmond, OKBuilt 1982 · S/N 414A0855 N8560YSullian John J · Alexandria, VAS/N 30-1707 N8564RAnderson Hans C · Leavenworth, WABuilt 1974 · S/N TH-534 N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711 N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714

Back to AD 2004-25-16 R1