AD 2012-01-10

Registered aircraft · 702

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:2012-01-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-01-10')
  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.

N8390ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7390N83UFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 5083N8409NDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7409N8416BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7416N843GSReserve Aircrafts LLC · New York, NYBuilt 1995 · S/N 5184N8458ALogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7458N845ASDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 7324N845SASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7965N8492CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7492N8495BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7495N8501FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7501N8505QAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7505N8506CAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7506N8515FAm Pm Services LLC - Series One · Northbrook, ILBuilt 2001 · S/N 7515N8516CAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7516N851GKKkh Rentals Inc · San Antonio, TXBuilt 2006 · S/N 5643N8525BAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7525N8532GAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7532N8533DAm Pm Services Llcblue Sky Series · Northbrook, ILBuilt 2001 · S/N 7533N8541DAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7541N854ASSkywest Airlines Inc · St. George, UTBuilt 2000 · S/N 7382N8554AAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7554N855MMMarklyn Jet Parts LLC · Dallas, TXBuilt 1990 · S/N 5064N855RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000077N8560FAm Pm Services LLC - Blue Skies Series · Northbrook, ILBuilt 2001 · S/N 7560N856ASSkywest Airlines Inc · St George, UTBuilt 2000 · S/N 7404N856PPWkair4 LLC · Boerne, TXBuilt 2001 · S/N 5483N8577DAm Pm Services LLC · Northbrook, ILBuilt 2001 · S/N 7577N857RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000079N8580AAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7580N8587EAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7587N860RWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000084N861RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000094N862RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000098N863RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000100N864RWRepublic Airways Inc · Carmel, INBuilt 2006 · S/N 17000117N8665AAm Pm Services LLC - Departure Series · Northbrook, ILBuilt 2002 · S/N 7665N8672AAm Pm Services LLC Departure Series · Northbrook, ILBuilt 2002 · S/N 7672N8694ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2002 · S/N 7694N871ASFrontera Flight Holdings Inc · Dover, DEBuilt 2001 · S/N 7537N872BCBcc Aviation LLC · Dover, DEBuilt 2000 · S/N 5479N873ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7549N874ASCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7551N875ASCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7559N876ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7576N877ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7579N877HChallenger 5445 LLC · Allentown, PABuilt 2000 · S/N 5445N878ASSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7590N879ASSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7600N880ASSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7606
Back to AD 2012-01-10