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.

N799JBNiner Jay Bee Aviation LLC · Middletown, DEBuilt 1970 · S/N 310Q0097N799NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 4496437N799TEEaster John E II · Bremo Bluff, VAS/N 310P-0004N799TFGallien Anthony · Livermore, CAS/N 421B0324N799VDReznik David · San Jose, CABuilt 1967 · S/N 310N-0023N79APHigh Tide Aviation LLC · Naples, FLBuilt 1979 · S/N TJ206N79ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 340A1248N79BACampbell Allen · Marietta, PAS/N 30-1842N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263N79CEBe 58 Corp · Rochester, NYS/N TH-2099N79DCBnb Marine LLC · Miami, FLS/N 414A0212N79DFMei Multi-Engine Instruction LLC · York, PABuilt 1975 · S/N TC-1883N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278N79GBurke Robert · Pierre, SDBuilt 1964 · S/N 30-362N79HLIndiana Paging Network Inc · Laporte, INS/N 27-7954046N79JFFour Twenty One LLC · Kalispell, MTBuilt 1977 · S/N 421C0340N79JTCalifornia In Nice Inc · San Jose, CABuilt 1979 · S/N 44-7995255N79LDTcb Aviation LLC · Evansville, INBuilt 1982 · S/N 31-8252062N79LKGonzalez Leon · Pembroke Pines, FLBuilt 1980 · S/N 31-8012092N79MFSkyking Aviation Services LLC · Carson City, NVBuilt 1979 · S/N 27-7954098N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516N79RJDelp Gregory E · Woodbury, CTBuilt 1968 · S/N 310P0055N79TDFlying Bs LLC · Canby, ORBuilt 1972 · S/N 421B0325N7AEAndrew Reed Enterprises LLC · Fostoria, MIBuilt 1965 · S/N 320D0033N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802N7DHBrown Michael D · Bloomington, INBuilt 1970 · S/N TH-118N7DMNix Terry W · Golden, MSBuilt 1972 · S/N TH-214N7EWMidas Aviation LLC · Royal Palm Beach, FLBuilt 1964 · S/N TC-764N7EYCharnwood Aviation Inc Trustee · Wilmington, DEBuilt 1964 · S/N 30571N7FLCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N 31T-7820082N7HTJohns Aviation LLC · Dawson, GABuilt 1967 · S/N 30-1643N7HURoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1968 · S/N 30-1710N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718N7JESale Reported · Rogersville, MOSale reported, pending cancellationBuilt 1967 · S/N 30-1618N7LLBautista Sean P · Reedley, CABuilt 1974 · S/N 310Q1019N7MWSeven Aces LLC · Chesterfield, NJBuilt 1982 · S/N TH-1353N7PD426th Aero Squadron LLC · Cropwell, ALBuilt 2000 · S/N TH-1972N7PFCrisp Curtis S · Lakewood, WABuilt 1969 · S/N P-52N7VRAja Aviation LLC · Hutchinson, MNBuilt 1978 · S/N 31T-7804010N7WKAll Above Town Ltd · Wilmington, DES/N 310Q0426N7WLKriner Andrew V · Orlando, FLBuilt 1969 · S/N 30-1914N7WPPoole Wesley Page · Young Harris, GABuilt 1967 · S/N TC-1044N7YMN7ym LLC · Rockford, MIBuilt 1969 · S/N 301900N8000Burns Christopher G · Hanover, PABuilt 1965 · S/N 30-682N8001YMyers Russell E · Pine, AZS/N 30-1107N8005MSmith Art · Dublin, CABuilt 1964 · S/N 310I0005N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009N8006MKeesee Patrick L · The Villages, FLBuilt 1964 · S/N 310I0006N8006YBreeding Jarrard L · Sharpsburg, GABuilt 1966 · S/N 30-1112
Back to AD 2004-25-16 R1