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.

N774KVTjr Aviation LLC · Allentown, PABuilt 1982 · S/N 31T-8166057 N7750QJohnson Gregory L · Orange, CABuilt 1973 · S/N 340-0200 N7750YWelden Charles R · Hoover, ALFirst renewal noticeBuilt 1965 · S/N 30-853 N77555Hmc Aero LLC · Ayer, MABuilt 1974 · S/N 340-0359 N7755KSkyview Aviation LLC · Benton, KYS/N TC2067 N7758BMiller Jeffrey A Trustee · Tucson, AZBuilt 1982 · S/N TJ-394 N7758YMead Aviation LLC · Missoula, MTBuilt 1965 · S/N 30-790 N775RAMojave 775ra LLC · Roseburg, ORBuilt 1982 · S/N 31P8414038 N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069 N775ZHundal Medical Corp · Malibu, CABuilt 1980 · S/N TJ283 N776Thomas Albuzat Inc · Westpoint, INNon-citizen corporation, flight hours not reportedBuilt 1969 · S/N P-111 N7760QBode Aviation Inc · Albuquerque, NMBuilt 1971 · S/N 310Q0260 N7761YBytes Aviation LLC · Poolesville, MDBuilt 1965 · S/N 30-848 N7762QAnagnos Nick C · East Moline, ILBuilt 1971 · S/N 310Q0262 N7763QJones Aviation Inc · Biggs, CABuilt 1971 · S/N 310Q0263 N7765YAce Vne LLC · Stevensville, MIBuilt 1965 · S/N 30-852 N7768QGress Gabrielle M · Bartow, FLBuilt 1971 · S/N 310Q0268 N7769QValla Joseph P · Santa Clarita, CABuilt 1971 · S/N 310Q0269 N776CHHassler William J · Houston, TXBuilt 1965 · S/N 30-753 N776DADavisair Inc · Raleigh, NCBuilt 1993 · S/N TH-1697 N776ESherman Litchfield LLC · Little Compton, RIBuilt 1961 · S/N 310-0108 N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078 N776MFBering Capital LLC · Anchorage, AKBuilt 1981 · S/N 34-8133186 N776PAMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME-284 N776PSPyle Dana C · Naples, FLBuilt 1974 · S/N TC-1815 N776TFStanking Holdings LLC · Wayzata, MNBuilt 2008 · S/N 20800500 N776WBcww LLC · Bakersfield, CABuilt 1980 · S/N 31-8052165 N776WCWingtip Corporation · Valparaiso, INS/N TH-570 N7770LEiler Donald L · Des Moines, WABuilt 1974 · S/N 34-7570046 N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857 N7773QValentine Russell P · Saint Petersburg, FLBuilt 1971 · S/N 310Q0273 N7773RHeikes Derek M · Denton, TXBuilt 1968 · S/N TC-1181 N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859 N7774RTruman Operations Limited Partnership · Imperial, NEBuilt 1969 · S/N TC-1228 N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191 N7774YReed John · Seattle, WABuilt 1965 · S/N 30-860 N77770Bredder Brett A · Brighton, COS/N 320D0058 N7777YDigati Anthony J · Mentone, CAS/N 30-863 N7778Q1974 310q LLC · Redmond, WAS/N 310Q0278 N7778YSpiegel Eitan · San Francisco, CABuilt 1965 · S/N 30-864 N7779YMccool Kenneth W · Olive Branch, MSBuilt 1965 · S/N 30-865 N777BWJones Gregory Noel · Waldorf, MDBuilt 1964 · S/N 310I0120 N777CGGilbert Charles L · Belleair, FLBuilt 1972 · S/N 310Q-0537 N777DPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1981 · S/N 340A-1257 N777DRPollock Jordan E · Nolensville, TNBuilt 1973 · S/N 310Q0940 N777EConner Ernest A · Dallas, TXBuilt 1981 · S/N TJ-347 N777FSCasey William F · Ponderay, IDBuilt 1972 · S/N 39-121 N777HZCb Auto Inc · Columbia, MDS/N 31-7405177 N777JRMiloud Chadd K · Fort Worth, TXBuilt 1972 · S/N 34-7350093 N777JYKingslyn Ltd · Wilmington, DEBuilt 1978 · S/N 31-7912004

Back to AD 2004-25-16 R1