OpenAirDocs.org
AD 2004-25-21

Registered aircraft · 431

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-21')
    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-21')
  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.

N935AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500920N935JXDelux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145175N937JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145254N939AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500923N939AJContinental 678 Fund LLC · Leesburg, VABuilt 2005 · S/N 14500939N940JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145295N941LTAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500926N942LLAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500930N947JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145610N948JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145638N949JXDelux Public Charter LLC · Dallas, TXS/N 145639N950JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145640N952JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145476N954JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145632N955JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145496N956JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145459N957JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145278N958JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145289N959JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145465N960JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145479N961JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145605N962JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145618N963JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145633N970DCCbg LLC · Wilsonville, ORBuilt 2004 · S/N 14500837N971DCCbg LLC · Wilsonville, ORBuilt 2004 · S/N 14500821N972DCCbg LLC · Wilsonville, ORBuilt 2004 · S/N 14500812N973DCCbg LLC · Wilsonville, ORBuilt 2001 · S/N 145393N974DCCbg LLC · Wilsonville, ORBuilt 2013 · S/N 14501186N975DCCbg LLC · Wilsonville, ORBuilt 2013 · S/N 14501185N976DCCbg LLC · Englewood, COBuilt 2001 · S/N 145514N977DCCbg LLC · Englewood, COBuilt 2001 · S/N 145370
Back to AD 2004-25-21