Skip to content

Registered aircraft · 158

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:2012-12-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:2012-12-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:2012-12-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:2012-12-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:2012-12-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:2012-12-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.

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 N945MTMed-Trans Corp · Denton, TXBuilt 2021 · S/N 9871

Back to AD 2012-12-21