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.

N3494BLiguori Fred C · Granby, CTBuilt 1955 · S/N 23-282N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094N3495QBoswell Alan · Chrisney, INBuilt 1967 · S/N 320E-0095N3497PKitchens Craig N · Salt Lake City, UTBuilt 1958 · S/N 23-1473N3499PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1475N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34AGJ D Aviation Leasing LLC · Mundelein, ILS/N 421C0901N34AWValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 340A0097N34BFSam Aviation LLC · Elberton, GABuilt 1975 · S/N 34-7670029N34BWMaintenance Forecasters Inc · Falmouth, MIBuilt 1974 · S/N TC-1691N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469N34EECodingflyboy LLC · Hayward, CABuilt 1966 · S/N 30-1138N34EHWisconsin Aviation Inc · Watertown, WIBuilt 1993 · S/N 3448031N34ESTough Old Bird Aviation LLC · Beavercreek, OHBuilt 1973 · S/N 34-7450078N34HM71wg LLC · Tulsa, OKBuilt 1980 · S/N 31T-8004057N34KGEldon Jensen Funeral Properties Inc · Lemmon, SDBuilt 1983 · S/N 34-8333059N34KKLe Ferrand Colette · Kalispell, MTBuilt 1972 · S/N 27-7304946N34LMNorfolknway LLC · Mount Pleasant, SCS/N 34-7770133N34MIII Enterprises LLC · Britton, SDBuilt 1975 · S/N 31P-7630007N34MYParis Air Inc · Vero Beach, FLS/N 34-7450088N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196N34PFAircraft Trustee Services Inc Trustee · Dover, DES/N 3449228N34RABurke William G III · Fayetteville, GABuilt 1964 · S/N 30-342N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943N34TLAmeagle Aviation LLC · Coventry, CTBuilt 1977 · S/N 340A0423N34WM70 North LLC · Anchorage, AKBuilt 1973 · S/N 31-7305125N34WWChute Aviation LLC · Prescott, AZBuilt 1973 · S/N 340-0258N34ZXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 3449010N3509W92nd West Aviation Inc · Lonoke, ARS/N TH-350N350ABierlein Aviation LLC · Midland, MIBuilt 1977 · S/N 340A0325N350AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496575N350CHFly Bye LLC · Georgetown, DEBuilt 1973 · S/N 310Q0910N350CYMowotech Inc · Boca Raton, FLBuilt 1978 · S/N 31-7852010N350DTDestination Alaska Air Service LLC · Homer, AKBuilt 1984 · S/N 31-8452010N350FMF M Aero Inc · Calhoun, GAS/N 31-8152043N350GBCarto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052136N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120N350KCLegare Aviation LLC · Murrells Inlet, SCBuilt 1979 · S/N 317952104N350LUValiair Limited Co Trustee · Casper, WYS/N 31-8352032N350SDAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1970 · S/N 310Q0065N3516AAirplane 2 LLC · Sedona, AZBuilt 1979 · S/N 31-7952106N3517AMunoz Pedro L · Ontario, NYBuilt 1969 · S/N TC-1305N35187Collins Daniel W Jr · Alvarado, TXS/N 31-7912056N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N351RRHolder Joiy R · Port Saint Lucie, FLBuilt 1964 · S/N TC-763N3520XGv Air Inc · Medford, ORBuilt 1979 · S/N 31-7912067N3522Barnett Charles J · St Peter JerseyBuilt 1969 · S/N 30-1787N3523DQuick Gas Aviation LLC · Thomasville, GABuilt 1979 · S/N 31-7952112
Back to AD 2004-25-16 R1