Skip to content

Registered aircraft · 306

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

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

N906VUVanderbilt University Medical Center · Nashville, TNBuilt 2009 · S/N 0788 N908ACAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0412 N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021 N911CKEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 0138 N911EFAir Methods LLC · Greenwood Village, COS/N 0497 N911ERAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0764 N911ETEast Texas Air One LLC · Nashville, TNBuilt 2007 · S/N 0541 N911KBMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0095 N911KSMed-Trans Corp · Denton, TXBuilt 2011 · S/N 1012 N911RZAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0834 N911SVSaint Vincents Healthcare · Billings, MTBuilt 2007 · S/N 0598 N911UGAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0416 N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132 N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154 N911XCMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 0143 N911XFAir Med Services LLC · Lafayette, LAFirst renewal noticeBuilt 2000 · S/N 0167 N911XGAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0157 N911XHAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0161 N911XJAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0763 N911XKAir Med Services LLC · Lafayette, LABuilt 2011 · S/N 0972 N911XMAir Med Services LLC · Lafayette, LABuilt 2013 · S/N 1105 N911XUAir Med Services LLC · Lafayette, LAS/N 0713 N911ZGGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2001 · S/N 0164 N912BFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0344 N912EFAir Methods LLC · Greenwood Village, COS/N 0421 N912UTMetro Aviation Inc · Shreveport, LABuilt 2009 · S/N 0858 N913ETEast Texas Air One LLC · Nashville, TNBuilt 2007 · S/N 0562 N914ETEast Texas Air One LLC · Nashville, TNBuilt 1997 · S/N 0018 N914THAir Methods LLC · Greenwood Village, COS/N 0440 N915ACAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0563 N915MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2010 · S/N 0910 N917ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0351 N917UTwiga Air LLC · Wilmington, DEBuilt 2007 · S/N 0550 N920AHMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0699 N920NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 0472 N922NHLta Group Holdings LLC · Amarillo, TXBuilt 2013 · S/N 1101 N930NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 0461 N932MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2010 · S/N 0922 N933NHLta Group Holdings LLC · Amarillo, TXBuilt 2009 · S/N 0847 N935ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0346 N935MCMetro Aviation Inc · Shreveport, LAS/N 0485 N941TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2008 · S/N 0667 N944MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2010 · S/N 0945 N951TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2010 · S/N 0942 N952ALAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0627 N953ALAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0686 N954ALAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0694 N955ALAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0554 N957ALAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0548 N958ALAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0655

Back to AD 2016-11-21