OpenAirDocs.org
AD 2012-23-07

Registered aircraft · 75

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-23-07')
    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-23-07')
  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.

N640ECMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 0064N831LFInhs Leasing Co LLC · Aurora, ORBuilt 1998 · S/N 0073N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052N908ACAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0412N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021N911CKEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 0138N911EFAir Methods LLC · Greenwood Village, COS/N 0497N911KBMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0095N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154N911XCMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 0143N911XFAir Med Services LLC · Lafayette, LAFirst renewal noticeBuilt 2000 · S/N 0167N911XGAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0157N911XHAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0161N911ZGGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2001 · S/N 0164N912BFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0344N912EFAir Methods LLC · Greenwood Village, COS/N 0421N914ETEast Texas Air One LLC · Nashville, TNBuilt 1997 · S/N 0018N914THAir Methods LLC · Greenwood Village, COS/N 0440N917ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0351N935ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0346N935MCMetro Aviation Inc · Shreveport, LAS/N 0485N959ALAir Methods LLC · Greenwood Village, COS/N 0361N986LFAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0385
Back to AD 2012-23-07