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.

N5045QPuma Aviaton LLC · Tracy City, TNBuilt 1968 · S/N 310N-0145N5045YWingsolutions Corp · Miami Lakes, FLS/N 27-2054N5047QRoundy Steve G · St George, UTBuilt 1968 · S/N 310N-0147N5049TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250210N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26N504KSJb522 LLC · Pflugerville, TXS/N 31-8012075N5051TOverton Asset Group LLC · Saint Marys, IABuilt 1972 · S/N 34-7250237N5052QSwanson Rodney Blake · Katy, TXBuilt 1968 · S/N 310N-0152N5053QHoovers Truck & Equipment LLC · Dover, OHBuilt 1968 · S/N 310N-0153N5057QCloud Dancer Aviation LLC · Chino Hills, CAS/N 310N-0157N505CMStout Walter J · White Hills, AZBuilt 1968 · S/N 310N-0155N505CNLes Amis Air LLC · Dorado, PRBuilt 1978 · S/N 414A0201N505GAlford Robert S · Columbus, GARegistration revokedBuilt 1964 · S/N 30-251N505GEWgm Solutions LLC · Mart, TXBuilt 1971 · S/N P-186N505KBBrowder Mark E · Charlotte, NCBuilt 1976 · S/N TC-2004N505LTLaufer Air Inc · Hartford, WIBuilt 1978 · S/N 421C0617N505RWCor Group LLC · Arlington, WAS/N 421B0268N505SFLux William E · Newman Lake, WABuilt 1977 · S/N 340A0261N5061QLepper Michael J · Ward, COBuilt 1971 · S/N 340-0017N5063QNorthern Hydraulic Dredge Co Inc · Harrisville, MIBuilt 1968 · S/N 310N-0163N50648Lindsey Aviation Services · Haslet, TXBuilt 1990 · S/N 20800191N5064CEaton Roger C · Vernon, NYBuilt 1974 · S/N 27-7405376N5065RZ J Express LLC · Lewes, DEBuilt 2002 · S/N TH-2040N5066QChristen Darryl K · Houma, LABuilt 1968 · S/N 310N-0166N5067QTuckey Patrick · Waxahachie, TXBuilt 1968 · S/N 310N-0167N5068QManis Joe Dan · Laurinburg, NCBuilt 1968 · S/N 310N-0168N506JMAims Community College · Greeley, COBuilt 2018 · S/N 4496432N5071YFletchers Aviation LLC · Mason, NHS/N 27-2085N5079YDiaz Apolo · Kansas City, MOBuilt 1962 · S/N 27-2097N507JBDi Marco Michael G · Orlando, FLBuilt 1979 · S/N 27-7954051N507TFairchild Property Management LLC · Monterey, CABuilt 1968 · S/N TC-1111N507THLeyva Maria · Edgewater, FLBuilt 1971 · S/N 34-7250037N5081QAsani Ilirian L · Alton, ILBuilt 1968 · S/N 310N-0181N5081YDoumis Joy S · Marathon, FLBuilt 1962 · S/N 27-2099N5082YTanner Greg · Bend, ORBuilt 1962 · S/N 27-2100N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497N5089YLewis Aaron J · Salado, TXS/N 27-2109N508RJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 20800315N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N5096RProvestment International LLC · West Melbourne, FLBuilt 2001 · S/N TH-1996N5097QIntravaia Anthony J · Mountain View, CABuilt 1968 · S/N 310N-0197N5097YBlackburn Anthony C · Mcdonough, GABuilt 1962 · S/N 27-2122N5098QM&L Engine LLC · Schriever, LABuilt 1971 · S/N 340-0024N509DPX-Jet Logistics LLC · Chino Hills, CAS/N 310J0099N509GCN509gc LLC · Branford, CTS/N 27-7854086N509JETwo Percent Aviation LLC · Lewes, DEBuilt 2009 · S/N 20800509N509PTailwindsbikelyft LLC · Hannibal, MOBuilt 2000 · S/N TH-1947N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228
Back to AD 2004-25-16 R1