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.

N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401N7680NTpc Air LLC · Colleyville, TXBuilt 1968 · S/N TC-1154N7681FLowrance Kenneth D · Saint Louis, MOBuilt 1976 · S/N 34-7770066N7681QArizona Sky Ventures LLC · Lewes, DES/N 310Q0460N7681YTaft Aviation LLC · Brookhaven, NYBuilt 1965 · S/N 30-759N7684CDecastro Edward A · Laramie, WYBuilt 1976 · S/N 34-7570260N7685QStrowhouer William J III · Media, PAS/N 310Q0464N7685YNehrbass Douglas J · Clarksville, TNBuilt 1965 · S/N 30-765N7686YMontana Leasing Group LLC · Park City, UTBuilt 1965 · S/N 30-766N7687QPfs Air Inc · Yellville, ARBuilt 1972 · S/N 310Q0466N7688QKallio Eric M · Gonzales, LABuilt 1972 · S/N 310Q0467N7689YGitlow Stuart · Woonsocket, RIBuilt 1965 · S/N 30-769N768WMcwilliams Russell · Flower Mound, TXBuilt 1977 · S/N TC-2108N7692YAloof Aviation LLC · Denver, COBuilt 1965 · S/N 30-774N7693YSkywalker Flight School LLC · Adrian, MIBuilt 1965 · S/N 30-775N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024N7695YGriffith David B · Gilmer, TXBuilt 1965 · S/N 30-777N7697YRegistration Pending · Rosamond, CARegistration pending, canceledBuilt 1965 · S/N 30-780N769ACAircraft Propulsion Leasing LLC · Holland, OHBuilt 1978 · S/N TK-89N769MCRhs Consulting Ltd · Reno, NVBuilt 1973 · S/N 31P-7300131N769RJWings South Inc · Fayetteville, GABuilt 1963 · S/N TC-536N769TTBrawndair Geminus LLC · Chesapeake, VABuilt 1975 · S/N 34-7570012N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100N76AZHubbard Broadcasting · Saint Paul, MNBuilt 1988 · S/N 20800139N76BTEstes David Edward · Kennesaw, GAS/N 33701935N76DUL&P Of Mke LLC · Milwaukee, WIBuilt 1978 · S/N ME-52N76FCBlackhawk Holding Corp · Wilmington, DEBuilt 1976 · S/N 27-7654082N76HFRgp Aviation LLC · The Villages, FLBuilt 1976 · S/N 33701729N76HKDodson International Parks Inc · Rantoul, KSBuilt 1958 · S/N 23-1423N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176N76KTWarriors With Wings LLC · Zebulon, NCBuilt 1974 · S/N 414-0508N76KWTriple Bee Transport LLC · Leon, WVBuilt 1980 · S/N TC-2318N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204N76MKMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME186N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909N76NKNaples Jet Management LLC · Naples, FLS/N ME-334N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158N76PBPlastic Bottle Corporation · Libertyville, ILBuilt 1978 · S/N 34-7970067N76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LABuilt 1972 · S/N 27-7304976N76VCBel Air Holdings Inc · Wilmington, DEBuilt 1982 · S/N TH-1361N76WCGolf Aero Corp · Arlington, TXBuilt 1975 · S/N 34-7670053N76WDLittle Evin M · Bidwell, OHS/N 340A0099N7700QConcept Sales Inc · Hartford, SDBuilt 1971 · S/N 310Q0410N7701AEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496089N7702BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496090N7703CEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496091N7703YNixon Christopher M · Washington, INBuilt 1965 · S/N 30-789N7704DSkyborne Airlines Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496092N7706YHighway Whisperer LLC · Wilmington, DES/N 30-794N7707GAtd Pilot Training LLC · Kansas City, MOBuilt 2001 · S/N 4496096
Back to AD 2004-25-16 R1