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.

N696JGTaylor Workforce Housing LLC · Wichita Falls, TXS/N 34-8070065 N696SGAtl Pilot LLC · Senoia, GABuilt 1984 · S/N 31-8452018 N69704Donahue Paul · West Palm Beach, FLBuilt 1973 · S/N 310Q0930 N69708South Seattle College · Seattle, WABuilt 1973 · S/N 310Q0933 N6970LMulligan David E · Andover, KSBuilt 1966 · S/N 310K0070 N6970YBell Daniel E · Alexandria, KYBuilt 1969 · S/N 27-4337 N6971LCw Equipment Rentals Inc · Biggs, CABuilt 1966 · S/N 310K0071 N6971YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1969 · S/N 27-4338 N69723O'Brien John P · Centerville, OHBuilt 1973 · S/N 310Q0942 N69728Sharff Steven T · Georgetown, DEBuilt 1973 · S/N 310Q0945 N69729Eastern Florida State College · Cocoa, FLBuilt 1973 · S/N 310Q0946 N69743Howard Richard J · Sioux Falls, SDS/N 310Q0955 N69744Registered aircraftBuilt 1973 · S/N 310Q0956 N69754Elevated 7 LLC · Kalispell, MTBuilt 1973 · S/N 310Q0961 N69797N69797 LLC · Denver, COBuilt 1973 · S/N 310Q0983 N6979LIntravaia Anthony J · Saint Louis, MOS/N 310K0079 N697JBDaccarett Marcos · Boise, IDBuilt 1976 · S/N 34-7770035 N697NDSouth Dakota State University · Brookings, SDBuilt 2015 · S/N 4496385 N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008 N69831Epic Aviation Services LLC · Kemah, TXBuilt 1973 · S/N 310Q1005 N69842D2 Aviation LLC · League City, TXBuilt 1974 · S/N 310Q1012 N69846Billingsley Arthur B · Green Cove Springs, FLBuilt 1974 · S/N 310Q1016 N69848Onaero Inc · Santa Monica, CABuilt 1974 · S/N 310Q1017 N6985JAvel Aircraft Inc · West Chicago, ILBuilt 1976 · S/N 34-7670309 N6988LCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N 310K0088 N698ACRaging Thermal Sky Sports LLC · Brighton, COS/N TC-1304 N698DRAtm Asset Management LLC · Nashville, TNFirst renewal noticeS/N 421C0235 N698HNelson Bobby E · Naples, FLBuilt 1968 · S/N 27-4106 N698NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 4496637 N698VWSheppard Louis A · Queens Village, NYBuilt 1974 · S/N 31-7405408 N69937Hellix LLC · Charlotte, NCBuilt 1974 · S/N 310Q1028 N69938Stapleton John Blase · Gulf Shores, ALBuilt 1974 · S/N 310Q1029 N69942Columbus State Community College · Columbus, OHBuilt 1974 · S/N 310Q1033 N6994LVance Austin Leasing Enterprises Inc · Blytheville, ARFirst renewal noticeBuilt 1966 · S/N 310K0094 N69951Cosper Jared L · Austin, TXBuilt 1974 · S/N 310Q1042 N6995LBaker James W · Wildwood, MOBuilt 1966 · S/N 310K0095 N6996AGrape Soda Adventures LLC · Weddington, NCBuilt 1979 · S/N 27-8054012 N6997LMcnutt Chris L · Anna, TXBuilt 1966 · S/N 310K0097 N699BBProfi-Vision Inc · Fogelsville, PABuilt 1981 · S/N TJ-334 N699JHLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1969 · S/N 337-1021 N699JSJustin Seth Drach Pa · Jacksonville, FLBuilt 1975 · S/N 421B0941 N699PSMcmillen Yachts Inc · Newport, RIBuilt 1998 · S/N TH1856 N699TGTkg Aviation Inc · Port Orange, FLBuilt 1978 · S/N 414A0081 N699WSGivens Byron Keith Jr · Warner Robins, GAS/N 310Q1050 N69AJKolea Leasing LLC · Honolulu, HIBuilt 1966 · S/N 27-3112 N69BWJet & Rotor Aviation LLC · Sacramento, CABuilt 1982 · S/N 34-8233087 N69CLTspy Services Inc · Nicholasville, KYBuilt 2000 · S/N TH-1949 N69FLFlx Holding Co LLC · Boca Raton, FLS/N 27-7654162 N69HBRowe Michael J · Crest Hill, ILBuilt 1974 · S/N 310Q1024 N69LCConsol Air Inc · Youngsville, NCS/N TJ-438

Back to AD 2004-25-16 R1