Skip to content

Registered aircraft · 159

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

N529MDFlight For Life Inc · Waukesha, WIBuilt 2021 · S/N 9870 N542AEAirbus Helicopters Inc · Grand Prairie, TXBuilt 2013 · S/N 9608 N545DUMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9832 N545KFAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9640 N55UVRector And Visitors Of The Uva Obo Medical Ctr · Charlottesville, VAS/N 9875 N575LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2007 · S/N 9114 N578AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 9578 N585CHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9588 N587MHAir Methods LLC · Greenwood Village, COS/N 9174 N592ACMetro Aviation Inc · Shreveport, LABuilt 2016 · S/N 9739 N602MMTrustees Of The University Of Pennsylvania · Philadelphia, PABuilt 2009 · S/N 9241 N608UWMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9850 N611SJAspirus Wausau Hospital Inc DBA · Wausau, WIBuilt 2009 · S/N 9303 N618GLGundersen Lutheran Medical Center Inc · La Crosse, WIBuilt 2016 · S/N 9760 N61UPTrustees Of The University Of Pennsylvania · Philadelphia, PABuilt 2012 · S/N 9556 N624ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2023 · S/N 9883 N635TJAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9635 N648BHFlight For Life Inc · Waukesha, WIBuilt 2021 · S/N 9869 N676LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2007 · S/N 9115 N745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZBuilt 2009 · S/N 9295 N759BHAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 9397 N766MEAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 9066 N770WSMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 9607 N779LFAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 9103 N78NCAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 9185 N814LVAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 9137 N816ECPitt County Memorial Hospital · Greenville, NCBuilt 2015 · S/N 9685 N824EHMetro Aviation Inc · Shreveport, LABuilt 2024 · S/N 9884 N84UCUc Health LLC · Cincinnati, OHBuilt 2022 · S/N 9873 N850UWMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9837 N854ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2010 · S/N 9327 N874BUMetro Aviation Inc · Shreveport, LABuilt 2022 · S/N 9874 N87MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2013 · S/N 9603 N893AUMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9862 N903SHSanford North · Sioux Falls, SDBuilt 2012 · S/N 9432 N906GLGundersen Lutheran Medical Center Inc · La Crosse, WIS/N 9089 N906SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9479 N908SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9482 N909SHSanford Health · Sioux Falls, SDBuilt 2010 · S/N 9359 N910NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 9084 N911BHAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 9545 N911MKAvera Mckennan · Sioux Falls, SDBuilt 2008 · S/N 9218 N911TBCook Children'S Health Enterprises · Fort Worth, TXBuilt 2009 · S/N 9281 N911TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2020 · S/N 9855 N911UWMetro Aviation Inc · Shreveport, LABuilt 2021 · S/N 9864 N912CCAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9595 N918ECPitt County Memorial Hospital Inc DBA · Greenville, NCBuilt 2007 · S/N 9121 N925ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2023 · S/N 9882 N944AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 9044 N944NHBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9181

Back to AD 2011-21-13