OpenAirDocs.org
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
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.

N815KKBristol Aircraft Leasing LLC · Montgomery, ALBuilt 1973 · S/N TC-1521N81615Heyl Holdings LLC · Orlando, FLBuilt 1953 · S/N 27-2322N8164DRowe Richard D · Corpus Christi, TXBuilt 1982 · S/N 34-8233086N8164YBrewer Steven G · Laconia, NHBuilt 1966 · S/N 30-1277N8165YCunningham Aviation LLC · Jackson, MSFirst renewal noticeBuilt 1980 · S/N 34-8070142N8166JTodd David A · Redmond, WABuilt 1980 · S/N 34-8070146N8166MMagafly LLC · Bay City, MIS/N 310I0166N8166QE S P Aviation LLC · Wilmington, DEBuilt 1972 · S/N 310Q0633N8166UEli Air Center Inc · Parkland, FLBuilt 1980 · S/N 34-8070173N8167MFrick Richard W · Sidell, ILBuilt 1964 · S/N 310I0167N8168MWilliams Charles S · Kingwood, TXBuilt 1964 · S/N 310I0168N816ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496535N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565N8170GBucher Max · Fort Mohave, AZBuilt 1982 · S/N 34-8233116N8172RDerby City Aviation LLC · Vero Beach, FLBuilt 1974 · S/N TH-515N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287N8174HBeitins Mark · Rockville, MDBuilt 1980 · S/N 34-8070155N8174RAngel Aviation Inc · Peoria, AZBuilt 1980 · S/N 34-8070157N8174SCs74s LLC · Naples, FLBuilt 1980 · S/N 34-8070166N8174YStansbury Todd V · Centennial, COS/N 30-1289N8175QMillenium Enterprises LLC · Naples, FLS/N 340-0522N8175RShilling Aeronautical Holdings LLC · Bradenton, FLBuilt 1974 · S/N TC-1754N8177MSouthern Sky Enterprises LLC · Lafayette, LABuilt 1964 · S/N 310I0177N8178MAcevedo Xochil · San Antonio, TXS/N 310I0178N817ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496536N817JBBenham James M · College Station, TXS/N 27-4561N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850N817LLJg Aero LLC · Clermont, FLS/N 421C0230N8180YG2g Aviation LLC · Wray, COBuilt 1966 · S/N 30-1296N8181GAirplane LLC · Coeur D Alene, IDS/N 421C0302N81835Martin Tully · Idalou, TXS/N 34-8233137N81837Central Sand & Gravel Inc · Alexandria, LABuilt 1982 · S/N 34-8233136N8184MAndrey Granin · Wantagh, NYBuilt 1964 · S/N 310I0184N8184QJohn Richard A · Southwest Ranches, FLBuilt 1972 · S/N 310Q0636N8186MNelson Justin S · Farr West, UTBuilt 1980 · S/N 348070179N8186RKarmic Aviation 1 LLC · Grand Rapids, MIBuilt 1980 · S/N 34-8070180N8186YHeiter Aviation Services LLC · Leesburg, INS/N 30-1303N8187HStover James L · Fredericksburg, VABuilt 1980 · S/N 44-8107002N8187YWhite Jack S · Boone, NCFirst renewal noticeBuilt 1966 · S/N 30-1304N8188SN156sl LLC · Oldsmar, FLBuilt 1982 · S/N 44-8207012N8188XClark Anthony · Augusta, KSBuilt 1980 · S/N 34-8070182N8188YFly Anytime LLC · Kankakee, ILBuilt 1966 · S/N 30-1305N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085N818BRMarc Inc · Bolton, MSBuilt 1981 · S/N 318152102N818CCFlyit LLC · Camas, WAS/N 27-2977N818DHCouch Fred · Fort Worth, TXS/N 421C0840N818MJPika Design Inc · Spring Hill, KSS/N 27-2486N818SFSierra Foxtrot LLC · Dodge City, KSBuilt 1980 · S/N 31T-8004018N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873
Back to AD 2004-25-16 R1